home *** CD-ROM | disk | FTP | other *** search
| MacBinary | 1994-07-26 | 127.5 KB | [CrDt/GMS ] |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was processed as: MacBinary
(archive/macBinary).
You can browse this item here: 4D Reference Demo
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 10%
| dexvert
| MacBinary (archive/macBinary)
| fallback
| Supported |
| 100%
| file
| MacBinary II, inited, Tue Jul 26 18:02:57 1994, modified Tue Jul 26 18:02:57 1994, creator 'GMS ', type 'CrDt' "4D Reference Demo", at 0x80 130429 bytes resource Apple HFS/HFS+ resource fork, map offset 0x1f519, map length 0x864, data length 0x1f419, at 16 0x020915ab, nextResourceMap 0xa0d704, fileRef 0x1668, list offset 0x1c, name offset 0x3aa, 4 types, 0x54455854 'TEXT' * 33 resource offset 0x22
| default (weak)
| |
| 99%
| file
| data
| default
| |
| 100%
| TrID
| MacBinary 2
| default (weak)
| |
| 100%
| lsar
| MacBinary
| default
|
|
| id metadata |
|---|
| key | value |
|---|
| macFileType | [CrDt] |
| macFileCreator | [GMS ] |
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 12 34 44 20 20 52 65 | 66 65 72 65 6e 63 65 20 |..4D Re|ference |
|00000010| 44 65 6d 6f 00 00 00 00 | 00 00 00 00 00 00 00 00 |Demo....|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 43 72 44 74 47 4d 53 | 20 01 00 00 00 00 00 00 |.CrDtGMS| .......|
|00000050| 00 00 00 00 00 00 00 00 | 01 fd 7d aa 5b 38 91 aa |........|..}.[8..|
|00000060| 5b 38 91 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |[8......|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 81 81 ba f4 00 00 |........|........|
|00000080| 00 00 01 00 00 01 f5 19 | 00 01 f4 19 00 00 08 64 |........|.......d|
|00000090| 02 09 15 ab c9 73 c4 ca | 65 4e ff 00 00 0c 48 a8 |.....s..|eN....H.|
|000000a0| 9f 65 72 00 12 08 01 00 | 00 12 f0 28 03 00 00 00 |.er.....|...(....|
|000000b0| 12 34 44 20 20 52 65 66 | 65 72 65 6e 63 65 20 44 |.4D Ref|erence D|
|000000c0| 65 6d 6f 52 02 00 00 00 | 43 72 44 74 47 4d 53 20 |emoR....|CrDtGMS |
|000000d0| 00 00 43 72 44 74 47 4d | 53 20 00 00 00 00 00 00 |..CrDtGM|S ......|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 aa 95 5d 93 00 00 | 00 00 00 01 fd 7d 60 01 |....]...|.....}`.|
|00000100| a9 62 28 01 6d 48 7f 55 | 01 10 28 c9 bd 01 00 fe |.b(.mH.U|..(.....|
|00000110| 11 66 16 7f 01 42 28 54 | 60 12 3f 06 a9 63 7f 11 |.f...B(T|`.?..c..|
|00000120| 11 7c 01 00 ff 54 11 60 | 24 18 20 54 50 88 43 ee |.|...T.`|$. TP.C.|
|00000130| ff f8 22 d8 22 d8 41 ee | ff f8 c8 4c 01 ff 76 60 |..".".A.|...L..v`|
|00000140| 2a 12 2f 0c 4e ba 01 00 | 76 12 50 8f 4c ee 01 10 |*./.N...|v.P.L...|
|00000150| c0 14 ff ec 4e 5e 4e 75 | 4e 56 12 ff f8 2f 0c 13 |....N^Nu|NV.../..|
|00000160| 28 6e 00 08 20 54 1b 50 | 88 43 ee ff f8 22 d8 22 |(n.. T.P|.C..."."|
|00000170| d8 41 ee ff f8 48 6e ff | f8 2f 0c 4e ba 11 00 7a |.A...Hn.|./.N...z|
|00000180| 00 00 08 6e 57 6f 72 6b | 69 6e 67 ca 57 69 74 68 |...nWork|ing.With|
|00000190| ca 44 6f 63 75 6d 65 6e | 74 73 0d 0d 54 68 65 20 |.Documen|ts..The |
|000001a0| 63 6f 6d 6d 61 6e 64 73 | 20 69 6e 20 74 68 69 73 |commands| in this|
|000001b0| 20 73 65 63 74 69 6f 6e | 20 61 6c 6c 6f 77 20 79 | section| allow y|
|000001c0| 6f 75 20 74 6f 20 77 6f | 72 6b 20 77 69 74 68 20 |ou to wo|rk with |
|000001d0| 64 6f 63 75 6d 65 6e 74 | 73 20 6f 6e 20 64 69 73 |document|s on dis|
|000001e0| 6b 2e 0d 0d 20 20 20 20 | 20 20 41 70 70 65 6e 64 |k... | Append|
|000001f0| ca 64 6f 63 75 6d 65 6e | 74 20 20 20 20 20 20 20 |.documen|t |
|00000200| 20 20 20 20 20 20 20 43 | 4c 4f 53 45 ca 44 4f 43 | C|LOSE.DOC|
|00000210| 55 4d 45 4e 54 0d 20 20 | 20 20 20 20 43 72 65 61 |UMENT. | Crea|
|00000220| 74 65 ca 64 6f 63 75 6d | 65 6e 74 20 20 20 20 20 |te.docum|ent |
|00000230| 20 20 20 20 20 20 20 20 | 20 20 44 45 4c 45 54 45 | | DELETE|
|00000240| ca 44 4f 43 55 4d 45 4e | 54 0d 20 20 20 20 20 20 |.DOCUMEN|T. |
|00000250| 4e 45 57 ca 44 41 54 41 | ca 46 49 4c 45 20 20 20 |NEW.DATA|.FILE |
|00000260| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 4f 70 | | Op|
|00000270| 65 6e ca 64 6f 63 75 6d | 65 6e 74 0d 20 20 20 20 |en.docum|ent. |
|00000280| 20 20 4f 50 45 4e ca 44 | 41 54 41 ca 46 49 4c 45 | OPEN.D|ATA.FILE|
|00000290| 0d 0d 0d 54 68 65 20 64 | 6f 63 75 6d 65 6e 74 20 |...The d|ocument |
|000002a0| 63 6f 6d 6d 61 6e 64 73 | 20 63 72 65 61 74 65 2c |commands| create,|
|000002b0| 20 6f 70 65 6e 2c 20 63 | 6c 6f 73 65 2c 20 61 6e | open, c|lose, an|
|000002c0| 64 20 64 65 6c 65 74 65 | 20 4d 61 63 69 6e 74 6f |d delete| Macinto|
|000002d0| 73 68 20 64 6f 63 75 6d | 65 6e 74 73 20 6f 6e 20 |sh docum|ents on |
|000002e0| 64 69 73 6b 2e 20 44 6f | 63 75 6d 65 6e 74 73 20 |disk. Do|cuments |
|000002f0| 63 61 6e 20 62 65 20 72 | 65 61 64 20 66 72 6f 6d |can be r|ead from|
|00000300| 20 61 6e 64 20 77 72 69 | 74 74 65 6e 20 74 6f 20 | and wri|tten to |
|00000310| 75 73 69 6e 67 20 74 68 | 65 20 63 6f 6d 6d 61 6e |using th|e comman|
|00000320| 64 73 20 52 45 43 45 49 | 56 45 ca 50 41 43 4b 45 |ds RECEI|VE.PACKE|
|00000330| 54 20 61 6e 64 20 53 45 | 4e 44 ca 50 41 43 4b 45 |T and SE|ND.PACKE|
|00000340| 54 2e 20 54 68 65 20 64 | 6f 63 75 6d 65 6e 74 73 |T. The d|ocuments|
|00000350| 20 6d 61 79 20 62 65 20 | 75 73 65 64 20 74 6f 20 | may be |used to |
|00000360| 73 74 6f 72 65 20 64 61 | 74 61 62 61 73 65 20 69 |store da|tabase i|
|00000370| 6e 66 6f 72 6d 61 74 69 | 6f 6e 2c 20 73 75 63 68 |nformati|on, such|
|00000380| 20 61 73 20 76 61 72 69 | 61 62 6c 65 73 2c 20 73 | as vari|ables, s|
|00000390| 65 74 73 2c 20 61 6e 64 | 20 63 6f 70 69 65 73 20 |ets, and| copies |
|000003a0| 6f 66 20 72 65 63 6f 72 | 64 73 2e 20 54 68 65 20 |of recor|ds. The |
|000003b0| 64 6f 63 75 6d 65 6e 74 | 73 20 63 61 6e 20 62 65 |document|s can be|
|000003c0| 20 61 6c 73 6f 20 62 65 | 20 63 72 65 61 74 65 64 | also be| created|
|000003d0| 20 74 6f 20 65 78 63 68 | 61 6e 67 65 20 69 6e 66 | to exch|ange inf|
|000003e0| 6f 72 6d 61 74 69 6f 6e | 20 77 69 74 68 20 6f 74 |ormation| with ot|
|000003f0| 68 65 72 20 61 70 70 6c | 69 63 61 74 69 6f 6e 73 |her appl|ications|
|00000400| 2e 0d 0d 59 6f 75 20 63 | 61 6e 20 6f 70 65 6e 20 |...You c|an open |
|00000410| 6d 75 6c 74 69 70 6c 65 | 20 64 6f 63 75 6d 65 6e |multiple| documen|
|00000420| 74 73 20 77 69 74 68 20 | 74 68 65 20 64 6f 63 75 |ts with |the docu|
|00000430| 6d 65 6e 74 20 63 6f 6d | 6d 61 6e 64 73 2e 20 54 |ment com|mands. T|
|00000440| 68 65 20 6e 75 6d 62 65 | 72 20 6f 66 20 6f 70 65 |he numbe|r of ope|
|00000450| 6e 20 64 6f 63 75 6d 65 | 6e 74 73 20 69 73 20 6c |n docume|nts is l|
|00000460| 69 6d 69 74 65 64 20 6f | 6e 6c 79 20 62 79 20 74 |imited o|nly by t|
|00000470| 68 65 20 4d 61 63 69 6e | 74 6f 73 68 20 66 69 6c |he Macin|tosh fil|
|00000480| 65 20 73 79 73 74 65 6d | 2e 20 48 6f 77 65 76 65 |e system|. Howeve|
|00000490| 72 2c 20 79 6f 75 20 73 | 68 6f 75 6c 64 20 63 6c |r, you s|hould cl|
|000004a0| 6f 73 65 20 61 6c 6c 20 | 64 6f 63 75 6d 65 6e 74 |ose all |document|
|000004b0| 73 20 74 68 61 74 20 64 | 6f 20 6e 6f 74 20 6e 65 |s that d|o not ne|
|000004c0| 65 64 20 74 6f 20 62 65 | 20 6f 70 65 6e 20 74 6f |ed to be| open to|
|000004d0| 20 61 76 6f 69 64 20 68 | 61 76 69 6e 67 20 74 6f | avoid h|aving to|
|000004e0| 6f 20 6d 61 6e 79 20 4d | 61 63 69 6e 74 6f 73 68 |o many M|acintosh|
|000004f0| 20 66 69 6c 65 73 20 6f | 70 65 6e 20 61 74 20 74 | files o|pen at t|
|00000500| 68 65 20 73 61 6d 65 20 | 74 69 6d 65 2e 0d 0d 0d |he same |time....|
|00000510| 54 68 65 20 64 6f 63 75 | 6d 65 6e 74 20 63 6f 6d |The docu|ment com|
|00000520| 6d 61 6e 64 73 20 75 73 | 65 20 64 6f 63 75 6d 65 |mands us|e docume|
|00000530| 6e 74 20 6e 61 6d 65 73 | 2e 20 41 20 64 6f 63 75 |nt names|. A docu|
|00000540| 6d 65 6e 74 20 6e 61 6d | 65 20 63 61 6e 20 63 6f |ment nam|e can co|
|00000550| 6e 74 61 69 6e 20 61 20 | 70 61 74 68 d1 74 68 65 |ntain a |path.the|
|00000560| 20 64 65 73 63 72 69 70 | 74 69 6f 6e 20 6f 66 20 | descrip|tion of |
|00000570| 74 68 65 20 6c 6f 63 61 | 74 69 6f 6e 20 6f 66 20 |the loca|tion of |
|00000580| 61 20 64 6f 63 75 6d 65 | 6e 74 20 69 6e 20 61 20 |a docume|nt in a |
|00000590| 64 69 72 65 63 74 6f 72 | 79 2e 20 41 20 70 61 74 |director|y. A pat|
|000005a0| 68 20 74 6f 20 61 20 64 | 6f 63 75 6d 65 6e 74 20 |h to a d|ocument |
|000005b0| 69 73 20 63 6f 6e 73 74 | 72 75 63 74 65 64 20 61 |is const|ructed a|
|000005c0| 73 20 66 6f 6c 6c 6f 77 | 73 3a 0d 0d 20 20 20 20 |s follow|s:.. |
|000005d0| 20 20 76 6f 6c 75 6d 65 | 3a 66 6f 6c 64 65 72 31 | volume|:folder1|
|000005e0| 3a 20 2e 20 2e 20 2e 20 | 3a 66 6f 6c 64 65 72 4e |: . . . |:folderN|
|000005f0| 3a 64 6f 63 75 6d 65 6e | 74 0d 0d 0d 46 6f 72 20 |:documen|t...For |
|00000600| 65 78 61 6d 70 6c 65 2c | 20 74 6f 20 61 63 63 65 |example,| to acce|
|00000610| 73 73 20 61 20 64 6f 63 | 75 6d 65 6e 74 20 6e 61 |ss a doc|ument na|
|00000620| 6d 65 64 20 53 61 6c 65 | 73 20 54 61 62 6c 65 2c |med Sale|s Table,|
|00000630| 20 63 6f 6e 74 61 69 6e | 65 64 20 69 6e 20 61 20 | contain|ed in a |
|00000640| 66 6f 6c 64 65 72 20 6e | 61 6d 65 64 20 53 61 6c |folder n|amed Sal|
|00000650| 65 73 20 46 6f 6c 64 65 | 72 2c 20 69 6e 20 61 20 |es Folde|r, in a |
|00000660| 66 6f 6c 64 65 72 20 6e | 61 6d 65 64 20 42 75 73 |folder n|amed Bus|
|00000670| 69 6e 65 73 73 2c 20 73 | 61 76 65 64 20 6f 6e 20 |iness, s|aved on |
|00000680| 61 20 64 69 73 6b 20 28 | 61 20 76 6f 6c 75 6d 65 |a disk (|a volume|
|00000690| 29 20 6e 61 6d 65 64 20 | 4f 66 66 69 63 65 2c 20 |) named |Office, |
|000006a0| 74 68 65 20 70 61 74 68 | 20 77 6f 75 6c 64 20 62 |the path| would b|
|000006b0| 65 0d 0d 20 20 20 20 20 | 20 4f 66 66 69 63 65 3a |e.. | Office:|
|000006c0| 42 75 73 69 6e 65 73 73 | 3a 53 61 6c 65 73 20 46 |Business|:Sales F|
|000006d0| 6f 6c 64 65 72 3a 53 61 | 6c 65 73 20 54 61 62 6c |older:Sa|les Tabl|
|000006e0| 65 0d 0d 0d 49 66 20 61 | 20 64 6f 63 75 6d 65 6e |e...If a| documen|
|000006f0| 74 20 69 73 20 73 70 65 | 63 69 66 69 65 64 20 77 |t is spe|cified w|
|00000700| 69 74 68 6f 75 74 20 61 | 20 70 61 74 68 2c 20 69 |ithout a| path, i|
|00000710| 74 20 69 73 20 61 73 73 | 75 6d 65 64 20 74 6f 20 |t is ass|umed to |
|00000720| 62 65 20 69 6e 20 74 68 | 65 20 66 6f 6c 64 65 72 |be in th|e folder|
|00000730| 20 74 68 61 74 20 63 6f | 6e 74 61 69 6e 73 20 74 | that co|ntains t|
|00000740| 68 65 20 64 61 74 61 62 | 61 73 65 20 73 74 72 75 |he datab|ase stru|
|00000750| 63 74 75 72 65 20 66 69 | 6c 65 2e 0d 0d 34 74 68 |cture fi|le...4th|
|00000760| 20 44 49 4d 45 4e 53 49 | 4f 4e 20 6d 61 69 6e 74 | DIMENSI|ON maint|
|00000770| 61 69 6e 73 20 61 20 73 | 79 73 74 65 6d 20 76 61 |ains a s|ystem va|
|00000780| 72 69 61 62 6c 65 20 63 | 61 6c 6c 65 64 20 44 6f |riable c|alled Do|
|00000790| 63 75 6d 65 6e 74 2e 20 | 54 68 65 20 44 6f 63 75 |cument. |The Docu|
|000007a0| 6d 65 6e 74 20 73 79 73 | 74 65 6d 20 76 61 72 69 |ment sys|tem vari|
|000007b0| 61 62 6c 65 20 63 6f 6e | 74 61 69 6e 73 20 74 68 |able con|tains th|
|000007c0| 65 20 6e 61 6d 65 20 6f | 66 20 61 6e 64 20 70 61 |e name o|f and pa|
|000007d0| 74 68 20 74 6f 20 74 68 | 65 20 64 6f 63 75 6d 65 |th to th|e docume|
|000007e0| 6e 74 20 74 68 61 74 20 | 77 61 73 20 6c 61 73 74 |nt that |was last|
|000007f0| 20 61 63 63 65 73 73 65 | 64 2e 0d 0d 43 6f 6d 6d | accesse|d...Comm|
|00000800| 61 6e 64 73 20 74 68 61 | 74 20 6f 70 65 6e 20 61 |ands tha|t open a|
|00000810| 20 64 6f 63 75 6d 65 6e | 74 20 72 65 74 75 72 6e | documen|t return|
|00000820| 20 61 20 64 6f 63 75 6d | 65 6e 74 20 72 65 66 65 | a docum|ent refe|
|00000830| 72 65 6e 63 65 2e 20 59 | 6f 75 20 75 73 65 20 74 |rence. Y|ou use t|
|00000840| 68 65 20 64 6f 63 75 6d | 65 6e 74 20 72 65 66 65 |he docum|ent refe|
|00000850| 72 65 6e 63 65 20 74 6f | 20 61 63 63 65 73 73 20 |rence to| access |
|00000860| 74 68 65 20 64 6f 63 75 | 6d 65 6e 74 2e 20 59 6f |the docu|ment. Yo|
|00000870| 75 20 73 68 6f 75 6c 64 | 20 6e 65 76 65 72 20 6d |u should| never m|
|00000880| 6f 64 69 66 79 20 74 68 | 65 20 64 6f 63 75 6d 65 |odify th|e docume|
|00000890| 6e 74 20 72 65 66 65 72 | 65 6e 63 65 2e 20 57 68 |nt refer|ence. Wh|
|000008a0| 65 6e 20 61 20 64 6f 63 | 75 6d 65 6e 74 20 63 6f |en a doc|ument co|
|000008b0| 6d 6d 61 6e 64 20 72 65 | 74 75 72 6e 73 20 61 20 |mmand re|turns a |
|000008c0| 64 6f 63 75 6d 65 6e 74 | 20 72 65 66 65 72 65 6e |document| referen|
|000008d0| 63 65 2c 20 73 61 76 65 | 20 69 74 20 69 6e 20 61 |ce, save| it in a|
|000008e0| 20 76 61 72 69 61 62 6c | 65 20 61 6e 64 20 75 73 | variabl|e and us|
|000008f0| 65 20 74 68 65 20 76 61 | 72 69 61 62 6c 65 20 74 |e the va|riable t|
|00000900| 6f 20 72 65 66 65 72 20 | 74 6f 20 74 68 65 20 64 |o refer |to the d|
|00000910| 6f 63 75 6d 65 6e 74 2e | 0d 0d 59 6f 75 20 63 61 |ocument.|..You ca|
|00000920| 6e 20 75 73 65 20 61 20 | 6c 6f 63 61 6c 20 76 61 |n use a |local va|
|00000930| 72 69 61 62 6c 65 20 74 | 6f 20 73 74 6f 72 65 20 |riable t|o store |
|00000940| 74 68 65 20 64 6f 63 75 | 6d 65 6e 74 20 72 65 66 |the docu|ment ref|
|00000950| 65 72 65 6e 63 65 2c 20 | 62 75 74 20 62 65 20 63 |erence, |but be c|
|00000960| 61 72 65 66 75 6c 2e 20 | 49 66 20 74 68 65 20 70 |areful. |If the p|
|00000970| 72 6f 63 65 64 75 72 65 | 20 65 6e 64 73 20 61 6e |rocedure| ends an|
|00000980| 64 20 79 6f 75 20 68 61 | 76 65 20 6e 6f 74 20 63 |d you ha|ve not c|
|00000990| 6c 6f 73 65 64 20 74 68 | 65 20 64 6f 63 75 6d 65 |losed th|e docume|
|000009a0| 6e 74 2c 20 79 6f 75 20 | 77 69 6c 6c 20 6e 6f 74 |nt, you |will not|
|000009b0| 20 62 65 20 61 62 6c 65 | 20 74 6f 2c 20 62 65 63 | be able| to, bec|
|000009c0| 61 75 73 65 20 74 68 65 | 20 6c 6f 63 61 6c 20 76 |ause the| local v|
|000009d0| 61 72 69 61 62 6c 65 20 | 77 69 6c 6c 20 68 61 76 |ariable |will hav|
|000009e0| 65 20 62 65 65 6e 20 63 | 6c 65 61 72 65 64 2e 0d |e been c|leared..|
|000009f0| 0d 0d 00 00 10 0e 43 6f | 6d 70 69 6c 65 72 ca 44 |......Co|mpiler.D|
|00000a00| 69 72 65 63 74 69 76 65 | 73 0d 0d 0d 54 68 65 20 |irective|s...The |
|00000a10| 63 6f 6d 6d 61 6e 64 73 | 20 69 6e 20 74 68 69 73 |commands| in this|
|00000a20| 20 73 65 63 74 69 6f 6e | 20 61 72 65 20 75 73 65 | section| are use|
|00000a30| 64 20 74 6f 20 64 65 63 | 6c 61 72 65 20 74 68 65 |d to dec|lare the|
|00000a40| 20 76 61 72 69 61 62 6c | 65 73 20 75 73 65 64 20 | variabl|es used |
|00000a50| 62 79 20 79 6f 75 72 20 | 70 72 6f 63 65 64 75 72 |by your |procedur|
|00000a60| 65 73 2e 20 54 68 65 73 | 65 20 63 6f 6d 6d 61 6e |es. Thes|e comman|
|00000a70| 64 73 20 64 6f 20 6e 6f | 74 20 6e 65 65 64 20 74 |ds do no|t need t|
|00000a80| 6f 20 61 70 70 65 61 72 | 20 69 6e 20 61 6e 20 69 |o appear| in an i|
|00000a90| 6e 74 65 72 70 72 65 74 | 65 64 20 70 72 6f 63 65 |nterpret|ed proce|
|00000aa0| 64 75 72 65 2e 20 46 6f | 72 20 65 78 61 6d 70 6c |dure. Fo|r exampl|
|00000ab0| 65 2c 20 79 6f 75 20 63 | 6f 75 6c 64 20 70 75 74 |e, you c|ould put|
|00000ac0| 20 74 68 65 6d 20 69 6e | 20 61 20 70 72 6f 63 65 | them in| a proce|
|00000ad0| 64 75 72 65 20 63 61 6c | 6c 65 64 20 43 6f 6d 70 |dure cal|led Comp|
|00000ae0| 69 6c 65 72 20 74 68 61 | 74 20 69 73 20 6e 65 76 |iler tha|t is nev|
|00000af0| 65 72 20 65 78 65 63 75 | 74 65 64 2e 0d 0d 54 6f |er execu|ted...To|
|00000b00| 20 75 73 65 20 74 79 70 | 65 20 64 65 63 6c 61 72 | use typ|e declar|
|00000b10| 61 74 69 6f 6e 73 20 69 | 6e 20 61 6e 20 69 6e 74 |ations i|n an int|
|00000b20| 65 72 70 72 65 74 65 64 | 20 61 70 70 6c 69 63 61 |erpreted| applica|
|00000b30| 74 69 6f 6e 2c 20 74 68 | 65 20 63 6f 6d 6d 61 6e |tion, th|e comman|
|00000b40| 64 73 20 6d 75 73 74 20 | 62 65 20 65 78 65 63 75 |ds must |be execu|
|00000b50| 74 65 64 2e 0d 0d 20 20 | 20 20 20 20 43 5f 42 4f |ted... | C_BO|
|00000b60| 4f 4c 45 41 4e 20 28 76 | 61 72 69 61 62 6c 65 31 |OLEAN (v|ariable1|
|00000b70| 7b 3b 2e 2e 2e 3b 20 76 | 61 72 69 61 62 6c 65 4e |{;...; v|ariableN|
|00000b80| 7d 29 20 0d 20 20 20 20 | 20 20 43 5f 44 41 54 45 |}) . | C_DATE|
|00000b90| 20 28 76 61 72 69 61 62 | 6c 65 31 7b 3b 2e 2e 2e | (variab|le1{;...|
|00000ba0| 3b 20 76 61 72 69 61 62 | 6c 65 4e 7d 29 0d 20 20 |; variab|leN}). |
|00000bb0| 20 20 20 20 43 5f 47 52 | 41 50 48 20 28 76 61 72 | C_GR|APH (var|
|00000bc0| 69 61 62 6c 65 31 7b 3b | 2e 2e 2e 3b 20 76 61 72 |iable1{;|...; var|
|00000bd0| 69 61 62 6c 65 4e 7d 29 | 0d 20 20 20 20 20 20 43 |iableN})|. C|
|00000be0| 5f 49 4e 54 45 47 45 52 | 20 28 76 61 72 69 61 62 |_INTEGER| (variab|
|00000bf0| 6c 65 31 7b 3b 2e 2e 2e | 3b 20 76 61 72 69 61 62 |le1{;...|; variab|
|00000c00| 6c 65 4e 7d 29 20 0d 20 | 20 20 20 20 20 43 5f 4c |leN}) . | C_L|
|00000c10| 4f 4e 47 49 4e 54 20 28 | 76 61 72 69 61 62 6c 65 |ONGINT (|variable|
|00000c20| 31 7b 3b 2e 2e 2e 3b 20 | 76 61 72 69 61 62 6c 65 |1{;...; |variable|
|00000c30| 4e 7d 29 20 0d 20 20 20 | 20 20 20 43 5f 50 49 43 |N}) . | C_PIC|
|00000c40| 54 55 52 45 20 28 76 61 | 72 69 61 62 6c 65 31 7b |TURE (va|riable1{|
|00000c50| 3b 2e 2e 2e 3b 20 76 61 | 72 69 61 62 6c 65 4e 7d |;...; va|riableN}|
|00000c60| 29 20 0d 20 20 20 20 20 | 20 43 5f 50 4f 49 4e 54 |) . | C_POINT|
|00000c70| 45 52 20 28 76 61 72 69 | 61 62 6c 65 31 7b 3b 2e |ER (vari|able1{;.|
|00000c80| 2e 2e 3b 20 76 61 72 69 | 61 62 6c 65 4e 7d 29 20 |..; vari|ableN}) |
|00000c90| 0d 20 20 20 20 20 20 43 | 5f 52 45 41 4c 20 28 76 |. C|_REAL (v|
|00000ca0| 61 72 69 61 62 6c 65 31 | 7b 3b 2e 2e 2e 3b 20 76 |ariable1|{;...; v|
|00000cb0| 61 72 69 61 62 6c 65 4e | 7d 29 20 0d 20 20 20 20 |ariableN|}) . |
|00000cc0| 20 20 43 5f 54 45 58 54 | 20 28 76 61 72 69 61 62 | C_TEXT| (variab|
|00000cd0| 6c 65 31 7b 3b 2e 2e 2e | 3b 20 76 61 72 69 61 62 |le1{;...|; variab|
|00000ce0| 6c 65 4e 7d 29 20 0d 20 | 20 20 20 20 20 43 5f 54 |leN}) . | C_T|
|00000cf0| 49 4d 45 20 28 76 61 72 | 69 61 62 6c 65 31 7b 3b |IME (var|iable1{;|
|00000d00| 2e 2e 2e 3b 20 76 61 72 | 69 61 62 6c 65 4e 7d 29 |...; var|iableN})|
|00000d10| 0d 0d 76 61 72 69 61 62 | 6c 65 20 20 20 20 20 56 |..variab|le V|
|00000d20| 61 72 69 61 62 6c 65 20 | 20 20 20 20 20 20 4e 61 |ariable | Na|
|00000d30| 6d 65 20 6f 66 20 76 61 | 72 69 61 62 6c 65 28 73 |me of va|riable(s|
|00000d40| 29 20 74 6f 20 64 65 63 | 6c 61 72 65 0d 0d 0d 20 |) to dec|lare... |
|00000d50| 20 20 20 20 20 43 5f 53 | 54 52 49 4e 47 20 28 73 | C_S|TRING (s|
|00000d60| 69 7a 65 3b 20 76 61 72 | 69 61 62 6c 65 31 7b 3b |ize; var|iable1{;|
|00000d70| 2e 2e 2e 3b 20 76 61 72 | 69 61 62 6c 65 4e 7d 29 |...; var|iableN})|
|00000d80| 0d 0d 73 69 7a 65 09 20 | 20 20 20 20 20 20 20 4e |..size. | N|
|00000d90| 75 6d 62 65 72 09 20 20 | 20 20 20 20 20 53 69 7a |umber. | Siz|
|00000da0| 65 20 6f 66 20 74 68 65 | 20 73 74 72 69 6e 67 0d |e of the| string.|
|00000db0| 76 61 72 69 61 62 6c 65 | 09 20 20 56 61 72 69 61 |variable|. Varia|
|00000dc0| 62 6c 65 09 20 20 20 20 | 20 20 20 4e 61 6d 65 20 |ble. | Name |
|00000dd0| 6f 66 20 76 61 72 69 61 | 62 6c 65 28 73 29 20 74 |of varia|ble(s) t|
|00000de0| 6f 20 64 65 63 6c 61 72 | 65 0d 0d 0d 20 20 20 20 |o declar|e... |
|00000df0| 20 20 43 5f 42 4f 4f 4c | 45 41 4e 20 28 70 72 6f | C_BOOL|EAN (pro|
|00000e00| 63 65 64 75 72 65 3b 20 | 76 61 72 69 61 62 6c 65 |cedure; |variable|
|00000e10| 31 7b 3b 2e 2e 2e 3b 20 | 76 61 72 69 61 62 6c 65 |1{;...; |variable|
|00000e20| 4e 7d 29 20 0d 20 20 20 | 20 20 20 43 5f 44 41 54 |N}) . | C_DAT|
|00000e30| 45 20 28 70 72 6f 63 65 | 64 75 72 65 3b 20 76 61 |E (proce|dure; va|
|00000e40| 72 69 61 62 6c 65 31 7b | 3b 2e 2e 2e 3b 20 76 61 |riable1{|;...; va|
|00000e50| 72 69 61 62 6c 65 4e 7d | 29 20 0d 20 20 20 20 20 |riableN}|) . |
|00000e60| 20 43 5f 47 52 41 50 48 | 20 28 70 72 6f 63 65 64 | C_GRAPH| (proced|
|00000e70| 75 72 65 3b 20 76 61 72 | 69 61 62 6c 65 31 7b 3b |ure; var|iable1{;|
|00000e80| 2e 2e 2e 3b 20 76 61 72 | 69 61 62 6c 65 4e 7d 29 |...; var|iableN})|
|00000e90| 20 0d 20 20 20 20 20 20 | 43 5f 49 4e 54 45 47 45 | . |C_INTEGE|
|00000ea0| 52 20 28 70 72 6f 63 65 | 64 75 72 65 3b 20 76 61 |R (proce|dure; va|
|00000eb0| 72 69 61 62 6c 65 31 7b | 3b 2e 2e 2e 3b 20 76 61 |riable1{|;...; va|
|00000ec0| 72 69 61 62 6c 65 4e 7d | 29 20 0d 20 20 20 20 20 |riableN}|) . |
|00000ed0| 20 43 5f 4c 4f 4e 47 49 | 4e 54 20 28 70 72 6f 63 | C_LONGI|NT (proc|
|00000ee0| 65 64 75 72 65 3b 20 76 | 61 72 69 61 62 6c 65 31 |edure; v|ariable1|
|00000ef0| 7b 3b 2e 2e 2e 3b 20 76 | 61 72 69 61 62 6c 65 4e |{;...; v|ariableN|
|00000f00| 7d 29 20 0d 20 20 20 20 | 20 20 43 5f 50 49 43 54 |}) . | C_PICT|
|00000f10| 55 52 45 20 28 70 72 6f | 63 65 64 75 72 65 3b 20 |URE (pro|cedure; |
|00000f20| 76 61 72 69 61 62 6c 65 | 31 7b 3b 2e 2e 2e 3b 20 |variable|1{;...; |
|00000f30| 76 61 72 69 61 62 6c 65 | 4e 7d 29 0d 20 20 20 20 |variable|N}). |
|00000f40| 20 20 43 5f 50 4f 49 4e | 54 45 52 20 28 70 72 6f | C_POIN|TER (pro|
|00000f50| 63 65 64 75 72 65 3b 20 | 76 61 72 69 61 62 6c 65 |cedure; |variable|
|00000f60| 31 7b 3b 2e 2e 2e 3b 20 | 76 61 72 69 61 62 6c 65 |1{;...; |variable|
|00000f70| 4e 7d 29 20 0d 20 20 20 | 20 20 20 43 5f 52 45 41 |N}) . | C_REA|
|00000f80| 4c 20 28 70 72 6f 63 65 | 64 75 72 65 3b 20 76 61 |L (proce|dure; va|
|00000f90| 72 69 61 62 6c 65 31 7b | 3b 2e 2e 2e 3b 20 76 61 |riable1{|;...; va|
|00000fa0| 72 69 61 62 6c 65 4e 7d | 29 20 0d 20 20 20 20 20 |riableN}|) . |
|00000fb0| 20 43 5f 54 45 58 54 20 | 28 70 72 6f 63 65 64 75 | C_TEXT |(procedu|
|00000fc0| 72 65 3b 20 76 61 72 69 | 61 62 6c 65 31 7b 3b 2e |re; vari|able1{;.|
|00000fd0| 2e 2e 3b 20 76 61 72 69 | 61 62 6c 65 4e 7d 29 0d |..; vari|ableN}).|
|00000fe0| 20 20 20 20 20 20 43 5f | 54 49 4d 45 20 28 70 72 | C_|TIME (pr|
|00000ff0| 6f 63 65 64 75 72 65 3b | 20 76 61 72 69 61 62 6c |ocedure;| variabl|
|00001000| 65 31 7b 3b 2e 2e 2e 3b | 20 76 61 72 69 61 62 6c |e1{;...;| variabl|
|00001010| 65 4e 7d 29 0d 0d 70 72 | 6f 63 65 64 75 72 65 20 |eN})..pr|ocedure |
|00001020| 20 20 20 20 53 74 72 69 | 6e 67 20 20 20 20 20 20 | Stri|ng |
|00001030| 20 20 20 20 20 4e 61 6d | 65 20 6f 66 20 70 72 6f | Nam|e of pro|
|00001040| 63 65 64 75 72 65 0d 76 | 61 72 69 61 62 6c 65 20 |cedure.v|ariable |
|00001050| 20 20 20 20 20 20 20 56 | 61 72 69 61 62 6c 65 20 | V|ariable |
|00001060| 20 20 20 20 20 20 20 4e | 61 6d 65 20 6f 66 20 76 | N|ame of v|
|00001070| 61 72 69 61 62 6c 65 28 | 73 29 20 74 6f 20 70 72 |ariable(|s) to pr|
|00001080| 65 2d 64 65 63 6c 61 72 | 65 0d 0d 20 20 20 20 20 |e-declar|e.. |
|00001090| 20 43 5f 53 54 52 49 4e | 47 20 28 70 72 6f 63 65 | C_STRIN|G (proce|
|000010a0| 64 75 72 65 3b 20 73 69 | 7a 65 3b 20 76 61 72 69 |dure; si|ze; vari|
|000010b0| 61 62 6c 65 31 20 7b 3b | 2e 2e 2e 3b 20 76 61 72 |able1 {;|...; var|
|000010c0| 69 61 62 6c 65 4e 7d 29 | 0d 0d 70 72 6f 63 65 64 |iableN})|..proced|
|000010d0| 75 72 65 20 20 20 20 20 | 20 53 74 72 69 6e 67 20 |ure | String |
|000010e0| 20 20 20 20 20 20 20 20 | 4e 61 6d 65 20 6f 66 20 | |Name of |
|000010f0| 70 72 6f 63 65 64 75 72 | 65 0d 73 69 7a 65 20 20 |procedur|e.size |
|00001100| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 4e 75 6d | | Num|
|00001110| 62 65 72 20 20 20 20 20 | 20 20 53 69 7a 65 20 6f |ber | Size o|
|00001120| 66 20 74 68 65 20 73 74 | 72 69 6e 67 0d 76 61 72 |f the st|ring.var|
|00001130| 69 61 62 6c 65 20 20 20 | 20 20 20 20 20 20 56 61 |iable | Va|
|00001140| 72 69 61 62 6c 65 20 20 | 20 20 20 20 4e 61 6d 65 |riable | Name|
|00001150| 20 6f 66 20 76 61 72 69 | 61 62 6c 65 28 73 29 20 | of vari|able(s) |
|00001160| 74 6f 20 70 72 65 2d 64 | 65 63 6c 61 72 65 0d 0d |to pre-d|eclare..|
|00001170| 0d 0d 54 68 65 73 65 20 | 63 6f 6d 6d 61 6e 64 73 |..These |commands|
|00001180| 20 64 65 63 6c 61 72 65 | 20 76 61 72 69 61 62 6c | declare| variabl|
|00001190| 65 73 20 61 6e 64 20 63 | 61 73 74 20 74 68 65 20 |es and c|ast the |
|000011a0| 76 61 72 69 61 62 6c 65 | 73 20 61 73 20 61 20 73 |variable|s as a s|
|000011b0| 70 65 63 69 66 69 65 64 | 20 64 61 74 61 20 74 79 |pecified| data ty|
|000011c0| 70 65 2e 20 44 65 63 6c | 61 72 69 6e 67 20 76 61 |pe. Decl|aring va|
|000011d0| 72 69 61 62 6c 65 73 20 | 72 65 73 6f 6c 76 65 73 |riables |resolves|
|000011e0| 20 61 6d 62 69 67 75 69 | 74 69 65 73 20 63 6f 6e | ambigui|ties con|
|000011f0| 63 65 72 6e 69 6e 67 20 | 61 20 76 61 72 69 61 62 |cerning |a variab|
|00001200| 6c 65 27 73 20 64 61 74 | 61 20 74 79 70 65 2e 20 |le's dat|a type. |
|00001210| 49 66 20 61 20 76 61 72 | 69 61 62 6c 65 20 69 73 |If a var|iable is|
|00001220| 20 6e 6f 74 20 64 65 63 | 6c 61 72 65 64 20 77 69 | not dec|lared wi|
|00001230| 74 68 20 6f 6e 65 20 6f | 66 20 74 68 65 73 65 20 |th one o|f these |
|00001240| 63 6f 6d 6d 61 6e 64 73 | 2c 20 74 68 65 20 63 6f |commands|, the co|
|00001250| 6d 70 69 6c 65 72 20 77 | 69 6c 6c 20 61 74 74 65 |mpiler w|ill atte|
|00001260| 6d 70 74 20 74 6f 20 64 | 65 74 65 72 6d 69 6e 65 |mpt to d|etermine|
|00001270| 20 61 20 76 61 72 69 61 | 62 6c 65 27 73 20 64 61 | a varia|ble's da|
|00001280| 74 61 20 74 79 70 65 2e | 20 54 68 65 20 64 61 74 |ta type.| The dat|
|00001290| 61 20 74 79 70 65 20 6f | 66 20 61 20 76 61 72 69 |a type o|f a vari|
|000012a0| 61 62 6c 65 20 75 73 65 | 64 20 69 6e 20 61 20 6c |able use|d in a l|
|000012b0| 61 79 6f 75 74 20 69 73 | 20 6f 66 74 65 6e 20 64 |ayout is| often d|
|000012c0| 69 66 66 69 63 75 6c 74 | 20 66 6f 72 20 74 68 65 |ifficult| for the|
|000012d0| 20 63 6f 6d 70 69 6c 65 | 72 20 74 6f 20 64 65 74 | compile|r to det|
|000012e0| 65 72 6d 69 6e 65 2e 20 | 54 68 65 72 65 66 6f 72 |ermine. |Therefor|
|000012f0| 65 20 69 74 20 69 73 20 | 65 73 70 65 63 69 61 6c |e it is |especial|
|00001300| 6c 79 20 69 6d 70 6f 72 | 74 61 6e 74 20 74 68 61 |ly impor|tant tha|
|00001310| 74 20 79 6f 75 20 75 73 | 65 20 74 68 65 73 65 20 |t you us|e these |
|00001320| 63 6f 6d 6d 61 6e 64 73 | 20 74 6f 20 64 65 63 6c |commands| to decl|
|00001330| 61 72 65 20 61 20 76 61 | 72 69 61 62 6c 65 20 75 |are a va|riable u|
|00001340| 73 65 64 20 69 6e 20 61 | 20 6c 61 79 6f 75 74 2e |sed in a| layout.|
|00001350| 0d 0d 43 5f 42 4f 4f 4c | 45 41 4e 3a 20 43 61 73 |..C_BOOL|EAN: Cas|
|00001360| 74 73 20 65 61 63 68 20 | 73 70 65 63 69 66 69 65 |ts each |specifie|
|00001370| 64 20 76 61 72 69 61 62 | 6c 65 20 61 73 20 61 20 |d variab|le as a |
|00001380| 42 6f 6f 6c 65 61 6e 20 | 76 61 72 69 61 62 6c 65 |Boolean |variable|
|00001390| 2e 0d 0d 43 5f 44 41 54 | 45 3a 20 43 61 73 74 73 |...C_DAT|E: Casts|
|000013a0| 20 65 61 63 68 20 73 70 | 65 63 69 66 69 65 64 20 | each sp|ecified |
|000013b0| 76 61 72 69 61 62 6c 65 | 20 61 73 20 61 20 64 61 |variable| as a da|
|000013c0| 74 65 20 76 61 72 69 61 | 62 6c 65 2e 0d 0d 43 5f |te varia|ble...C_|
|000013d0| 47 52 41 50 48 3a 20 43 | 61 73 74 73 20 65 61 63 |GRAPH: C|asts eac|
|000013e0| 68 20 73 70 65 63 69 66 | 69 65 64 20 76 61 72 69 |h specif|ied vari|
|000013f0| 61 62 6c 65 20 61 73 20 | 61 20 67 72 61 70 68 20 |able as |a graph |
|00001400| 76 61 72 69 61 62 6c 65 | 2e 20 54 68 69 73 20 73 |variable|. This s|
|00001410| 68 6f 75 6c 64 20 62 65 | 20 75 73 65 64 20 77 68 |hould be| used wh|
|00001420| 65 6e 20 61 20 67 72 61 | 70 68 20 61 72 65 61 20 |en a gra|ph area |
|00001430| 69 73 20 63 72 65 61 74 | 65 64 20 69 6e 20 61 20 |is creat|ed in a |
|00001440| 6c 61 79 6f 75 74 2e 0d | 0d 43 5f 49 4e 54 45 47 |layout..|.C_INTEG|
|00001450| 45 52 3a 20 43 61 73 74 | 73 20 65 61 63 68 20 73 |ER: Cast|s each s|
|00001460| 70 65 63 69 66 69 65 64 | 20 76 61 72 69 61 62 6c |pecified| variabl|
|00001470| 65 20 61 73 20 61 6e 20 | 69 6e 74 65 67 65 72 20 |e as an |integer |
|00001480| 76 61 72 69 61 62 6c 65 | 2e 0d 0d 20 43 5f 4c 4f |variable|... C_LO|
|00001490| 4e 47 49 4e 54 3a 20 43 | 61 73 74 73 20 65 61 63 |NGINT: C|asts eac|
|000014a0| 68 20 73 70 65 63 69 66 | 69 65 64 20 76 61 72 69 |h specif|ied vari|
|000014b0| 61 62 6c 65 20 61 73 20 | 61 20 6c 6f 6e 67 20 69 |able as |a long i|
|000014c0| 6e 74 65 67 65 72 20 76 | 61 72 69 61 62 6c 65 2e |nteger v|ariable.|
|000014d0| 0d 0d 43 5f 50 49 43 54 | 55 52 45 3a 20 43 61 73 |..C_PICT|URE: Cas|
|000014e0| 74 73 20 65 61 63 68 20 | 73 70 65 63 69 66 69 65 |ts each |specifie|
|000014f0| 64 20 76 61 72 69 61 62 | 6c 65 20 61 73 20 61 20 |d variab|le as a |
|00001500| 70 69 63 74 75 72 65 20 | 76 61 72 69 61 62 6c 65 |picture |variable|
|00001510| 3b 20 79 6f 75 20 63 61 | 6e 20 70 65 72 66 6f 72 |; you ca|n perfor|
|00001520| 6d 20 70 69 63 74 75 72 | 65 20 6f 70 65 72 61 74 |m pictur|e operat|
|00001530| 69 6f 6e 73 20 6f 6e 6c | 79 20 6f 6e 20 76 61 72 |ions onl|y on var|
|00001540| 69 61 62 6c 65 73 20 74 | 68 61 74 20 68 61 76 65 |iables t|hat have|
|00001550| 20 62 65 65 6e 20 64 65 | 63 6c 61 72 65 64 20 61 | been de|clared a|
|00001560| 73 20 70 69 63 74 75 72 | 65 73 2e 0d 0d 43 5f 50 |s pictur|es...C_P|
|00001570| 4f 49 4e 54 45 52 3a 20 | 43 61 73 74 73 20 65 61 |OINTER: |Casts ea|
|00001580| 63 68 20 73 70 65 63 69 | 66 69 65 64 20 76 61 72 |ch speci|fied var|
|00001590| 69 61 62 6c 65 20 61 73 | 20 61 20 70 6f 69 6e 74 |iable as| a point|
|000015a0| 65 72 20 76 61 72 69 61 | 62 6c 65 2e 0d 0d 43 5f |er varia|ble...C_|
|000015b0| 52 45 41 4c 3a 20 43 61 | 73 74 73 20 65 61 63 68 |REAL: Ca|sts each|
|000015c0| 20 73 70 65 63 69 66 69 | 65 64 20 76 61 72 69 61 | specifi|ed varia|
|000015d0| 62 6c 65 20 61 73 20 61 | 20 72 65 61 6c 20 76 61 |ble as a| real va|
|000015e0| 72 69 61 62 6c 65 2e 0d | 0d 43 5f 54 45 58 54 3a |riable..|.C_TEXT:|
|000015f0| 20 43 61 73 74 73 20 65 | 61 63 68 20 73 70 65 63 | Casts e|ach spec|
|00001600| 69 66 69 65 64 20 76 61 | 72 69 61 62 6c 65 20 61 |ified va|riable a|
|00001610| 73 20 61 20 74 65 78 74 | 20 76 61 72 69 61 62 6c |s a text| variabl|
|00001620| 65 2e 0d 0d 43 5f 54 49 | 4d 45 3a 20 43 61 73 74 |e...C_TI|ME: Cast|
|00001630| 73 20 65 61 63 68 20 73 | 70 65 63 69 66 69 65 64 |s each s|pecified|
|00001640| 20 76 61 72 69 61 62 6c | 65 20 61 73 20 61 20 74 | variabl|e as a t|
|00001650| 69 6d 65 20 76 61 72 69 | 61 62 6c 65 2e 0d 0d 43 |ime vari|able...C|
|00001660| 5f 53 54 52 49 4e 47 3a | 20 43 61 73 74 73 20 65 |_STRING:| Casts e|
|00001670| 61 63 68 20 73 70 65 63 | 69 66 69 65 64 20 76 61 |ach spec|ified va|
|00001680| 72 69 61 62 6c 65 20 61 | 73 20 61 20 73 74 72 69 |riable a|s a stri|
|00001690| 6e 67 20 76 61 72 69 61 | 62 6c 65 2e 20 54 68 65 |ng varia|ble. The|
|000016a0| 20 73 69 7a 65 20 70 61 | 72 61 6d 65 74 65 72 20 | size pa|rameter |
|000016b0| 73 70 65 63 69 66 69 65 | 73 20 74 68 65 20 6c 65 |specifie|s the le|
|000016c0| 6e 67 74 68 20 6f 66 20 | 74 68 65 20 73 74 72 69 |ngth of |the stri|
|000016d0| 6e 67 20 74 68 65 20 76 | 61 72 69 61 62 6c 65 20 |ng the v|ariable |
|000016e0| 63 61 6e 20 63 6f 6e 74 | 61 69 6e 2e 20 41 20 73 |can cont|ain. A s|
|000016f0| 74 72 69 6e 67 20 76 61 | 72 69 61 62 6c 65 20 69 |tring va|riable i|
|00001700| 73 20 66 61 73 74 65 72 | 20 69 6e 20 75 73 65 20 |s faster| in use |
|00001710| 74 68 61 6e 20 61 20 74 | 65 78 74 20 76 61 72 69 |than a t|ext vari|
|00001720| 61 62 6c 65 2e 0d 0d 4e | 75 6d 65 72 69 63 20 6f |able...N|umeric o|
|00001730| 70 65 72 61 74 69 6f 6e | 73 20 6f 6e 20 6c 6f 6e |peration|s on lon|
|00001740| 67 20 69 6e 74 65 67 65 | 72 20 61 6e 64 20 69 6e |g intege|r and in|
|00001750| 74 65 67 65 72 20 76 61 | 72 69 61 62 6c 65 73 20 |teger va|riables |
|00001760| 61 72 65 20 75 73 75 61 | 6c 6c 79 20 6d 75 63 68 |are usua|lly much|
|00001770| 20 66 61 73 74 65 72 20 | 74 68 61 6e 20 6f 70 65 | faster |than ope|
|00001780| 72 61 74 69 6f 6e 73 20 | 6f 6e 20 74 68 65 20 64 |rations |on the d|
|00001790| 65 66 61 75 6c 74 20 6e | 75 6d 65 72 69 63 20 74 |efault n|umeric t|
|000017a0| 79 70 65 20 28 65 78 74 | 65 6e 64 65 64 29 2e 0d |ype (ext|ended)..|
|000017b0| 0d 0d 54 68 65 20 66 69 | 72 73 74 20 66 6f 72 6d |..The fi|rst form|
|000017c0| 20 6f 66 20 74 68 65 20 | 63 6f 6d 6d 61 6e 64 20 | of the |command |
|000017d0| 69 73 20 75 73 65 64 20 | 74 6f 20 74 79 70 65 20 |is used |to type |
|000017e0| 61 6e 79 20 76 61 72 69 | 61 62 6c 65 2e 20 54 68 |any vari|able. Th|
|000017f0| 69 73 20 66 6f 72 6d 20 | 63 61 6e 20 62 65 20 75 |is form |can be u|
|00001800| 73 65 64 20 69 6e 20 69 | 6e 74 65 72 70 72 65 74 |sed in i|nterpret|
|00001810| 65 64 20 64 61 74 61 62 | 61 73 65 73 2e 0d 0d 54 |ed datab|ases...T|
|00001820| 68 65 20 73 65 63 6f 6e | 64 20 66 6f 72 6d 20 6f |he secon|d form o|
|00001830| 66 20 74 68 65 20 63 6f | 6d 6d 61 6e 64 20 69 6e |f the co|mmand in|
|00001840| 20 77 68 69 63 68 20 70 | 72 6f 63 65 64 75 72 65 | which p|rocedure|
|00001850| 20 69 73 20 74 68 65 20 | 66 69 72 73 74 20 70 61 | is the |first pa|
|00001860| 72 61 6d 65 74 65 72 2c | 20 69 73 20 75 73 65 64 |rameter,| is used|
|00001870| 20 74 6f 20 74 79 70 65 | 20 76 61 72 69 61 62 6c | to type| variabl|
|00001880| 65 73 20 74 68 61 74 20 | 61 72 65 20 70 61 73 73 |es that |are pass|
|00001890| 65 64 20 74 6f 20 61 20 | 70 72 6f 63 65 64 75 72 |ed to a |procedur|
|000018a0| 65 2e 20 46 6f 72 20 65 | 78 61 6d 70 6c 65 2c 20 |e. For e|xample, |
|000018b0| 24 30 2c 20 24 31 2c 20 | 24 32 20 65 74 63 2e 20 |$0, $1, |$2 etc. |
|000018c0| 54 68 69 73 20 66 6f 72 | 6d 20 63 61 6e 6e 6f 74 |This for|m cannot|
|000018d0| 20 62 65 20 65 78 65 63 | 75 74 65 64 20 69 6e 20 | be exec|uted in |
|000018e0| 69 6e 74 65 72 70 72 65 | 74 65 64 20 6d 6f 64 65 |interpre|ted mode|
|000018f0| 2e 20 46 6f 72 20 74 68 | 69 73 20 72 65 61 73 6f |. For th|is reaso|
|00001900| 6e 2c 20 69 66 20 79 6f | 75 20 61 72 65 20 75 73 |n, if yo|u are us|
|00001910| 69 6e 67 20 74 68 69 73 | 20 73 79 6e 74 61 78 2c |ing this| syntax,|
|00001920| 20 6b 65 65 70 20 69 74 | 20 69 6e 20 61 20 70 72 | keep it| in a pr|
|00001930| 6f 63 65 64 75 72 65 20 | 74 68 61 74 20 69 73 20 |ocedure |that is |
|00001940| 6e 6f 74 20 65 78 65 63 | 75 74 65 64 20 69 6e 20 |not exec|uted in |
|00001950| 69 6e 74 65 72 70 72 65 | 74 65 64 20 6d 6f 64 65 |interpre|ted mode|
|00001960| 2e 0d 0d 0d 54 68 65 20 | 66 6f 6c 6c 6f 77 69 6e |....The |followin|
|00001970| 67 20 65 78 61 6d 70 6c | 65 20 74 79 70 65 73 20 |g exampl|e types |
|00001980| 74 68 65 20 24 31 20 70 | 61 72 61 6d 65 74 65 72 |the $1 p|arameter|
|00001990| 20 66 6f 72 20 74 68 65 | 20 70 72 6f 63 65 64 75 | for the| procedu|
|000019a0| 72 65 20 4d 79 50 72 6f | 63 65 64 75 72 65 20 61 |re MyPro|cedure a|
|000019b0| 73 20 49 6e 74 65 67 65 | 72 3a 0d 0d 20 20 20 20 |s Intege|r:.. |
|000019c0| 20 20 43 5f 49 4e 54 45 | 47 45 52 28 4d 79 50 72 | C_INTE|GER(MyPr|
|000019d0| 6f 63 65 64 75 72 65 3b | 20 24 31 29 20 0d 20 20 |ocedure;| $1) . |
|000019e0| 20 20 20 20 43 5f 4c 4f | 4e 47 6c 4e 54 28 4d 79 | C_LO|NGlNT(My|
|000019f0| 50 72 6f 63 65 64 75 72 | 65 3b 20 24 32 3b 20 24 |Procedur|e; $2; $|
|00001a00| 33 29 0d 0d 00 00 06 6e | 4d 75 6c 74 69 2d 55 73 |3).....n|Multi-Us|
|00001a10| 65 72 ca 43 6f 6d 6d 61 | 6e 64 73 0d 0d 0d 34 74 |er.Comma|nds...4t|
|00001a20| 68 20 44 49 4d 45 4e 53 | 49 4f 4e 20 61 6e 64 20 |h DIMENS|ION and |
|00001a30| 34 44 20 53 45 52 56 45 | 52 2f 34 44 20 43 4c 49 |4D SERVE|R/4D CLI|
|00001a40| 45 4e 54 20 61 75 74 6f | 6d 61 74 69 63 61 6c 6c |ENT auto|maticall|
|00001a50| 79 20 6d 61 6e 61 67 65 | 20 6d 75 6c 74 69 75 73 |y manage| multius|
|00001a60| 65 72 20 64 61 74 61 62 | 61 73 65 73 20 62 79 20 |er datab|ases by |
|00001a70| 70 72 65 76 65 6e 74 69 | 6e 67 20 6d 75 6c 74 69 |preventi|ng multi|
|00001a80| 2d 75 73 65 72 20 6f 72 | 20 6d 75 6c 74 69 2d 70 |-user or| multi-p|
|00001a90| 72 6f 63 65 73 73 20 63 | 6f 6e 66 6c 69 63 74 73 |rocess c|onflicts|
|00001aa0| 2e 20 54 77 6f 20 75 73 | 65 72 73 20 6f 72 20 74 |. Two us|ers or t|
|00001ab0| 77 6f 20 70 72 6f 63 65 | 73 73 65 73 20 63 61 6e |wo proce|sses can|
|00001ac0| 6e 6f 74 20 6d 6f 64 69 | 66 79 20 74 68 65 20 73 |not modi|fy the s|
|00001ad0| 61 6d 65 20 72 65 63 6f | 72 64 20 6f 72 20 6f 62 |ame reco|rd or ob|
|00001ae0| 6a 65 63 74 20 61 74 20 | 74 68 65 0d 73 61 6d 65 |ject at |the.same|
|00001af0| 20 74 69 6d 65 2e 20 48 | 6f 77 65 76 65 72 20 74 | time. H|owever t|
|00001b00| 68 65 20 73 65 63 6f 6e | 64 20 75 73 65 72 20 6f |he secon|d user o|
|00001b10| 72 20 70 72 6f 63 65 73 | 73 20 63 61 6e 20 68 61 |r proces|s can ha|
|00001b20| 76 65 20 72 65 61 64 2d | 6f 6e 6c 79 20 61 63 63 |ve read-|only acc|
|00001b30| 65 73 73 20 74 6f 20 74 | 68 65 20 72 65 63 6f 72 |ess to t|he recor|
|00001b40| 64 20 6f 72 20 6f 62 6a | 65 63 74 20 61 74 20 74 |d or obj|ect at t|
|00001b50| 68 65 20 73 61 6d 65 20 | 74 69 6d 65 2e 0d 0d 54 |he same |time...T|
|00001b60| 68 65 72 65 20 61 72 65 | 20 73 65 76 65 72 61 6c |here are| several|
|00001b70| 20 72 65 61 73 6f 6e 73 | 20 66 6f 72 20 75 73 69 | reasons| for usi|
|00001b80| 6e 67 20 74 68 65 20 6d | 75 6c 74 69 2d 75 73 65 |ng the m|ulti-use|
|00001b90| 72 20 63 6f 6d 6d 61 6e | 64 73 20 69 6e 20 74 68 |r comman|ds in th|
|00001ba0| 69 73 20 73 65 63 74 69 | 6f 6e 3a 0d 0d 20 20 20 |is secti|on:.. |
|00001bb0| 20 20 20 a5 20 4d 6f 64 | 69 66 79 69 6e 67 20 72 | . Mod|ifying r|
|00001bc0| 65 63 6f 72 64 73 20 62 | 79 20 75 73 69 6e 67 20 |ecords b|y using |
|00001bd0| 74 68 65 20 6c 61 6e 67 | 75 61 67 65 2e 0d 0d 20 |the lang|uage... |
|00001be0| 20 20 20 20 20 a5 20 55 | 73 69 6e 67 20 61 20 63 | . U|sing a c|
|00001bf0| 75 73 74 6f 6d 20 75 73 | 65 72 20 69 6e 74 65 72 |ustom us|er inter|
|00001c00| 66 61 63 65 20 66 6f 72 | 20 6d 75 6c 74 69 2d 75 |face for| multi-u|
|00001c10| 73 65 72 20 6f 70 65 72 | 61 74 69 6f 6e 73 2e 0d |ser oper|ations..|
|00001c20| 0d 20 20 20 20 20 20 a5 | 20 53 61 76 69 6e 67 20 |. .| Saving |
|00001c30| 72 65 6c 61 74 65 64 20 | 6d 6f 64 69 66 69 63 61 |related |modifica|
|00001c40| 74 69 6f 6e 73 20 69 6e | 73 69 64 65 20 61 20 74 |tions in|side a t|
|00001c50| 72 61 6e 73 61 63 74 69 | 6f 6e 2e 0d 0d 0d 54 68 |ransacti|on....Th|
|00001c60| 65 72 65 20 61 72 65 20 | 74 68 72 65 65 20 69 6d |ere are |three im|
|00001c70| 70 6f 72 74 61 6e 74 20 | 63 6f 6e 63 65 70 74 73 |portant |concepts|
|00001c80| 20 74 6f 20 62 65 20 61 | 77 61 72 65 20 6f 66 20 | to be a|ware of |
|00001c90| 77 68 65 6e 20 75 73 69 | 6e 67 20 63 6f 6d 6d 61 |when usi|ng comma|
|00001ca0| 6e 64 73 20 69 6e 20 61 | 20 6d 75 6c 74 69 2d 75 |nds in a| multi-u|
|00001cb0| 73 65 72 20 64 61 74 61 | 62 61 73 65 3a 0d 0d 20 |ser data|base:.. |
|00001cc0| 20 20 20 20 20 a5 20 45 | 61 63 68 20 66 69 6c 65 | . E|ach file|
|00001cd0| 20 69 73 20 69 6e 20 65 | 69 74 68 65 72 20 61 20 | is in e|ither a |
|00001ce0| 72 65 61 64 2d 6f 6e 6c | 79 20 6f 72 20 61 20 72 |read-onl|y or a r|
|00001cf0| 65 61 64 2d 77 72 69 74 | 65 20 73 74 61 74 65 2e |ead-writ|e state.|
|00001d00| 0d 0d 20 20 20 20 20 20 | a5 20 52 65 63 6f 72 64 |.. |. Record|
|00001d10| 73 20 62 65 63 6f 6d 65 | 20 6c 6f 63 6b 65 64 20 |s become| locked |
|00001d20| 77 68 65 6e 20 74 68 65 | 79 20 61 72 65 20 6c 6f |when the|y are lo|
|00001d30| 61 64 65 64 20 61 6e 64 | 20 75 6e 6c 6f 63 6b 65 |aded and| unlocke|
|00001d40| 64 20 77 68 65 6e 20 0d | 20 20 20 20 20 20 20 20 |d when .| |
|00001d50| 20 20 20 20 20 20 20 20 | 20 74 68 65 79 20 61 72 | | they ar|
|00001d60| 65 20 75 6e 6c 6f 61 64 | 65 64 2e 0d 0d 20 20 20 |e unload|ed... |
|00001d70| 20 20 20 a5 20 41 20 6c | 6f 63 6b 65 64 20 72 65 | . A l|ocked re|
|00001d80| 63 6f 72 64 20 63 61 6e | 6e 6f 74 20 62 65 20 6d |cord can|not be m|
|00001d90| 6f 64 69 66 69 65 64 2e | 0d 0d 0d 49 6e 20 74 68 |odified.|...In th|
|00001da0| 65 20 73 65 63 74 69 6f | 6e 73 20 74 68 61 74 20 |e sectio|ns that |
|00001db0| 66 6f 6c 6c 6f 77 2c 20 | 74 68 65 20 70 65 72 73 |follow, |the pers|
|00001dc0| 6f 6e 20 70 65 72 66 6f | 72 6d 69 6e 67 20 61 6e |on perfo|rming an|
|00001dd0| 20 6f 70 65 72 61 74 69 | 6f 6e 20 6f 6e 20 74 68 | operati|on on th|
|00001de0| 65 20 6d 75 6c 74 69 2d | 75 73 65 72 20 64 61 74 |e multi-|user dat|
|00001df0| 61 62 61 73 65 20 69 73 | 20 74 68 65 20 6c 6f 63 |abase is| the loc|
|00001e00| 61 6c 20 75 73 65 72 2e | 20 4f 74 68 65 72 20 70 |al user.| Other p|
|00001e10| 65 6f 70 6c 65 20 75 73 | 69 6e 67 20 74 68 65 20 |eople us|ing the |
|00001e20| 64 61 74 61 62 61 73 65 | 20 61 72 65 20 72 65 66 |database| are ref|
|00001e30| 65 72 72 65 64 20 74 6f | 20 61 73 20 74 68 65 20 |erred to| as the |
|00001e40| 6f 74 68 65 72 20 75 73 | 65 72 73 2e 20 54 68 65 |other us|ers. The|
|00001e50| 20 64 69 73 63 75 73 73 | 69 6f 6e 20 69 73 20 66 | discuss|ion is f|
|00001e60| 72 6f 6d 20 74 68 65 20 | 70 65 72 73 70 65 63 74 |rom the |perspect|
|00001e70| 69 76 65 20 6f 66 20 74 | 68 65 20 6c 6f 63 61 6c |ive of t|he local|
|00001e80| 20 75 73 65 72 2e 20 41 | 6c 73 6f 2c 20 66 72 6f | user. A|lso, fro|
|00001e90| 6d 20 61 20 6d 75 6c 74 | 69 2d 70 72 6f 63 65 73 |m a mult|i-proces|
|00001ea0| 73 20 70 65 72 73 70 65 | 63 74 69 76 65 2c 20 74 |s perspe|ctive, t|
|00001eb0| 68 65 20 70 72 6f 63 65 | 73 73 20 65 78 65 63 75 |he proce|ss execu|
|00001ec0| 74 69 6e 67 20 61 6e 20 | 6f 70 65 72 61 74 69 6f |ting an |operatio|
|00001ed0| 6e 20 6f 6e 20 74 68 65 | 20 64 61 74 61 62 61 73 |n on the| databas|
|00001ee0| 65 20 69 73 20 74 68 65 | 20 63 75 72 72 65 6e 74 |e is the| current|
|00001ef0| 20 70 72 6f 63 65 73 73 | 2e 20 41 6e 79 20 6f 74 | process|. Any ot|
|00001f00| 68 65 72 20 65 78 65 63 | 75 74 69 6e 67 20 70 72 |her exec|uting pr|
|00001f10| 6f 63 65 73 73 20 69 73 | 20 72 65 66 65 72 72 65 |ocess is| referre|
|00001f20| 64 20 74 6f 20 61 73 20 | 6f 74 68 65 72 20 70 72 |d to as |other pr|
|00001f30| 6f 63 65 73 73 65 73 2e | 20 54 68 65 20 64 69 73 |ocesses.| The dis|
|00001f40| 63 75 73 73 69 6f 6e 20 | 69 73 20 66 72 6f 6d 20 |cussion |is from |
|00001f50| 74 68 65 20 70 6f 69 6e | 74 20 6f 66 20 76 69 65 |the poin|t of vie|
|00001f60| 77 20 6f 66 20 74 68 65 | 20 63 75 72 72 65 6e 74 |w of the| current|
|00001f70| 20 70 72 6f 63 65 73 73 | 3a 0d 0d 20 20 20 20 20 | process|:.. |
|00001f80| 20 20 53 65 6d 61 70 68 | 6f 72 65 20 20 20 20 20 | Semaph|ore |
|00001f90| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001fa0| 20 20 20 20 20 43 4c 45 | 41 52 20 53 45 4d 41 50 | CLE|AR SEMAP|
|00001fb0| 48 4f 52 45 0d 20 20 20 | 20 20 20 4c 6f 63 6b 65 |HORE. | Locke|
|00001fc0| 64 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |d | |
|00001fd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001fe0| 53 54 41 52 54 20 54 52 | 41 4e 53 41 43 54 49 4f |START TR|ANSACTIO|
|00001ff0| 4e 0d 20 20 20 20 20 20 | 43 41 4e 43 45 4c 20 54 |N. |CANCEL T|
|00002000| 52 41 4e 53 41 43 54 49 | 4f 4e 20 20 20 20 20 20 |RANSACTI|ON |
|00002010| 20 20 20 20 52 45 41 44 | 20 57 52 49 54 45 0d 20 | READ| WRITE. |
|00002020| 20 20 20 20 20 52 45 41 | 44 20 4f 4e 4c 59 20 20 | REA|D ONLY |
|00002030| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002040| 20 20 20 20 20 20 20 20 | 4c 4f 43 4b 45 44 20 41 | |LOCKED A|
|00002050| 54 54 52 49 42 55 54 45 | 53 0d 20 20 20 20 20 20 |TTRIBUTE|S. |
|00002060| 56 41 4c 49 44 41 54 45 | 20 54 52 41 4e 53 41 43 |VALIDATE| TRANSAC|
|00002070| 54 49 4f 4e 0d 0d 00 00 | 07 c6 55 73 69 6e 67 20 |TION....|..Using |
|00002080| 43 6f 6d 6d 61 6e 64 73 | 20 69 6e 20 61 20 4d 75 |Commands| in a Mu|
|00002090| 6c 74 69 2d 75 73 65 72 | 20 44 61 74 61 62 61 73 |lti-user| Databas|
|000020a0| 65 0d 0d 0d 41 20 6e 75 | 6d 62 65 72 20 6f 66 20 |e...A nu|mber of |
|000020b0| 63 6f 6d 6d 61 6e 64 73 | 20 69 6e 20 74 68 65 20 |commands| in the |
|000020c0| 6c 61 6e 67 75 61 67 65 | 20 70 65 72 66 6f 72 6d |language| perform|
|000020d0| 20 73 70 65 63 69 66 69 | 63 20 61 63 74 69 6f 6e | specifi|c action|
|000020e0| 73 20 77 68 65 6e 20 74 | 68 65 79 20 65 6e 63 6f |s when t|hey enco|
|000020f0| 75 6e 74 65 72 20 61 20 | 72 65 63 6f 72 64 20 74 |unter a |record t|
|00002100| 68 61 74 20 69 73 20 6c | 6f 63 6b 65 64 2e 20 54 |hat is l|ocked. T|
|00002110| 68 65 79 20 62 65 68 61 | 76 65 20 6e 6f 72 6d 61 |hey beha|ve norma|
|00002120| 6c 6c 79 20 69 66 20 74 | 68 65 79 20 64 6f 20 6e |lly if t|hey do n|
|00002130| 6f 74 20 65 6e 63 6f 75 | 6e 74 65 72 20 61 20 6c |ot encou|nter a l|
|00002140| 6f 63 6b 65 64 20 72 65 | 63 6f 72 64 2e 20 48 65 |ocked re|cord. He|
|00002150| 72 65 20 69 73 20 61 20 | 6c 69 73 74 20 6f 66 20 |re is a |list of |
|00002160| 74 68 6f 73 65 20 63 6f | 6d 6d 61 6e 64 73 2c 20 |those co|mmands, |
|00002170| 73 68 6f 77 69 6e 67 20 | 74 68 65 20 61 63 74 69 |showing |the acti|
|00002180| 6f 6e 73 20 6f 66 20 65 | 61 63 68 20 77 68 65 6e |ons of e|ach when|
|00002190| 20 69 74 20 65 6e 63 6f | 75 6e 74 65 72 73 20 61 | it enco|unters a|
|000021a0| 20 6c 6f 63 6b 65 64 20 | 72 65 63 6f 72 64 2e 20 | locked |record. |
|000021b0| 0d 0d 0d a5 20 4d 4f 44 | 49 46 59 ca 52 45 43 4f |.... MOD|IFY.RECO|
|000021c0| 52 44 3a 20 54 68 69 73 | 20 63 6f 6d 6d 61 6e 64 |RD: This| command|
|000021d0| 20 64 69 73 70 6c 61 79 | 73 20 61 20 64 69 61 6c | display|s a dial|
|000021e0| 6f 67 20 62 6f 78 20 73 | 74 61 74 69 6e 67 20 74 |og box s|tating t|
|000021f0| 68 61 74 20 74 68 65 20 | 72 65 63 6f 72 64 20 69 |hat the |record i|
|00002200| 73 20 69 6e 20 75 73 65 | 2e 20 54 68 65 20 72 65 |s in use|. The re|
|00002210| 63 6f 72 64 20 69 73 20 | 6e 6f 74 20 64 69 73 70 |cord is |not disp|
|00002220| 6c 61 79 65 64 20 61 6e | 64 20 74 68 65 72 65 66 |layed an|d theref|
|00002230| 6f 72 65 20 74 68 65 20 | 75 73 65 72 20 63 61 6e |ore the |user can|
|00002240| 6e 6f 74 20 6d 6f 64 69 | 66 79 20 74 68 65 20 72 |not modi|fy the r|
|00002250| 65 63 6f 72 64 2e 20 49 | 6e 20 74 68 65 20 75 73 |ecord. I|n the us|
|00002260| 65 72 20 65 6e 76 69 72 | 6f 6e 6d 65 6e 74 2c 20 |er envir|onment, |
|00002270| 74 68 65 20 72 65 63 6f | 72 64 20 69 73 20 73 68 |the reco|rd is sh|
|00002280| 6f 77 6e 20 69 6e 20 72 | 65 61 64 20 6f 6e 6c 79 |own in r|ead only|
|00002290| 20 73 74 61 74 65 2e 0d | 0d a5 20 4d 4f 44 49 46 | state..|.. MODIF|
|000022a0| 59 ca 53 45 4c 45 43 54 | 49 4f 4e 3a 20 54 68 69 |Y.SELECT|ION: Thi|
|000022b0| 73 20 63 6f 6d 6d 61 6e | 64 20 62 65 68 61 76 65 |s comman|d behave|
|000022c0| 73 20 6e 6f 72 6d 61 6c | 6c 79 20 65 78 63 65 70 |s normal|ly excep|
|000022d0| 74 20 77 68 65 6e 20 74 | 68 65 20 75 73 65 72 20 |t when t|he user |
|000022e0| 64 6f 75 62 6c 65 2d 63 | 6c 69 63 6b 73 20 61 20 |double-c|licks a |
|000022f0| 72 65 63 6f 72 64 20 74 | 6f 20 6d 6f 64 69 66 79 |record t|o modify|
|00002300| 20 69 74 2e 20 4d 4f 44 | 49 46 59 ca 53 45 4c 45 | it. MOD|IFY.SELE|
|00002310| 43 54 49 4f 4e 20 64 69 | 73 70 6c 61 79 73 20 61 |CTION di|splays a|
|00002320| 20 64 69 61 6c 6f 67 20 | 62 6f 78 20 73 74 61 74 | dialog |box stat|
|00002330| 69 6e 67 20 74 68 61 74 | 20 74 68 65 20 72 65 63 |ing that| the rec|
|00002340| 6f 72 64 20 69 73 20 69 | 6e 20 75 73 65 20 61 6e |ord is i|n use an|
|00002350| 64 20 74 68 65 6e 20 61 | 6c 6c 6f 77 73 20 72 65 |d then a|llows re|
|00002360| 61 64 2d 6f 6e 6c 79 20 | 61 63 63 65 73 73 20 74 |ad-only |access t|
|00002370| 6f 20 74 68 65 20 72 65 | 63 6f 72 64 2e 0d 0d a5 |o the re|cord....|
|00002380| 20 41 50 50 4c 59 ca 54 | 4f ca 53 45 4c 45 43 54 | APPLY.T|O.SELECT|
|00002390| 49 4f 4e 3a 20 49 20 68 | 69 73 20 63 6f 6d 6d 61 |ION: I h|is comma|
|000023a0| 6e 64 20 6c 6f 61 64 73 | 20 61 20 6c 6f 63 6b 65 |nd loads| a locke|
|000023b0| 64 20 72 65 63 6f 72 64 | 2c 20 62 75 74 20 64 6f |d record|, but do|
|000023c0| 65 73 20 6e 6f 74 20 6d | 6f 64 69 66 79 20 69 74 |es not m|odify it|
|000023d0| 2e 20 41 50 50 4c 59 ca | 54 4f ca 53 45 4c 45 43 |. APPLY.|TO.SELEC|
|000023e0| 54 49 4f 4e 20 63 61 6e | 20 62 65 20 75 73 65 64 |TION can| be used|
|000023f0| 20 74 6f 20 72 65 61 64 | 20 69 6e 66 6f 72 6d 61 | to read| informa|
|00002400| 74 69 6f 6e 20 66 72 6f | 6d 20 74 68 65 20 66 69 |tion fro|m the fi|
|00002410| 6c 65 20 77 69 74 68 6f | 75 74 20 73 70 65 63 69 |le witho|ut speci|
|00002420| 61 6c 20 63 61 72 65 2e | 20 49 66 20 74 68 65 20 |al care.| If the |
|00002430| 63 6f 6d 6d 61 6e 64 20 | 65 6e 63 6f 75 6e 74 65 |command |encounte|
|00002440| 72 73 20 61 20 6c 6f 63 | 6b 65 64 20 72 65 63 6f |rs a loc|ked reco|
|00002450| 72 64 2c 20 74 68 65 20 | 6c 6f 63 6b 65 64 20 72 |rd, the |locked r|
|00002460| 65 63 6f 72 64 20 69 73 | 20 70 75 74 20 69 6e 74 |ecord is| put int|
|00002470| 6f 20 74 68 65 20 4c 6f | 63 6b 65 64 53 65 74 20 |o the Lo|ckedSet |
|00002480| 73 79 73 74 65 6d 20 73 | 65 74 2e 0d 0d a5 20 44 |system s|et.... D|
|00002490| 45 4c 45 54 45 ca 53 45 | 4c 45 43 54 49 4f 4e 3a |ELETE.SE|LECTION:|
|000024a0| 20 6c 20 68 69 73 20 63 | 6f 6d 6d 61 6e 64 20 64 | l his c|ommand d|
|000024b0| 6f 65 73 20 6e 6f 74 20 | 64 65 6c 65 74 65 20 61 |oes not |delete a|
|000024c0| 6e 79 20 6c 6f 63 6b 65 | 64 20 72 65 63 6f 72 64 |ny locke|d record|
|000024d0| 73 2e 20 49 74 20 73 6b | 69 70 73 20 74 68 65 20 |s. It sk|ips the |
|000024e0| 6c 6f 63 6b 65 64 20 72 | 65 63 6f 72 64 73 2e 20 |locked r|ecords. |
|000024f0| 49 66 20 69 74 20 65 6e | 63 6f 75 6e 74 65 72 73 |If it en|counters|
|00002500| 20 61 20 6c 6f 63 6b 65 | 64 20 72 65 63 6f 72 64 | a locke|d record|
|00002510| 2c 20 74 68 65 20 6c 6f | 63 6b 65 64 20 72 65 63 |, the lo|cked rec|
|00002520| 6f 72 64 20 69 73 20 70 | 75 74 20 69 6e 74 6f 20 |ord is p|ut into |
|00002530| 74 68 65 20 4c 6f 63 6b | 65 64 53 65 74 20 73 79 |the Lock|edSet sy|
|00002540| 73 74 65 6d 20 73 65 74 | 2e 0d 0d a5 20 44 45 4c |stem set|.... DEL|
|00002550| 45 54 45 ca 52 45 43 4f | 52 44 3a 20 54 20 68 69 |ETE.RECO|RD: T hi|
|00002560| 73 20 63 6f 6d 6d 61 6e | 64 20 69 73 20 69 67 6e |s comman|d is ign|
|00002570| 6f 72 65 64 20 69 66 20 | 74 68 65 20 72 65 63 6f |ored if |the reco|
|00002580| 72 64 20 69 73 20 6c 6f | 63 6b 65 64 2e 20 4e 6f |rd is lo|cked. No|
|00002590| 20 65 72 72 6f 72 20 69 | 73 20 72 65 74 75 72 6e | error i|s return|
|000025a0| 65 64 2e 20 59 6f 75 20 | 6d 75 73 74 20 74 65 73 |ed. You |must tes|
|000025b0| 74 20 74 68 61 74 20 74 | 68 65 20 72 65 63 6f 72 |t that t|he recor|
|000025c0| 64 20 69 73 20 75 6e 6c | 6f 63 6b 65 64 20 62 65 |d is unl|ocked be|
|000025d0| 66 6f 72 65 20 65 78 65 | 63 75 74 69 6e 67 20 74 |fore exe|cuting t|
|000025e0| 68 69 73 20 63 6f 6d 6d | 61 6e 64 2e 0d 0d a5 20 |his comm|and.... |
|000025f0| 53 41 56 45 ca 52 45 43 | 4f 52 44 3a 20 49 20 68 |SAVE.REC|ORD: I h|
|00002600| 69 73 20 63 6f 6d 6d 61 | 6e 64 20 69 73 20 69 67 |is comma|nd is ig|
|00002610| 6e 6f 72 65 64 20 69 66 | 20 74 68 65 20 72 65 63 |nored if| the rec|
|00002620| 6f 72 64 20 69 73 20 6c | 6f 63 6b 65 64 2e 20 4e |ord is l|ocked. N|
|00002630| 6f 20 65 72 72 6f 72 20 | 69 73 20 72 65 74 75 72 |o error |is retur|
|00002640| 6e 65 64 2e 20 59 6f 75 | 20 6d 75 73 74 20 74 65 |ned. You| must te|
|00002650| 73 74 20 74 68 61 74 20 | 74 68 65 20 72 65 63 6f |st that |the reco|
|00002660| 72 64 20 69 73 20 75 6e | 6c 6f 63 6b 65 64 20 62 |rd is un|locked b|
|00002670| 65 66 6f 72 65 20 65 78 | 65 63 75 74 69 6e 67 20 |efore ex|ecuting |
|00002680| 74 68 69 73 20 63 6f 6d | 6d 61 6e 64 2e 0d 0d a5 |this com|mand....|
|00002690| 20 41 52 52 41 59 ca 54 | 4f ca 53 45 4c 45 43 54 | ARRAY.T|O.SELECT|
|000026a0| 49 4f 4e 3a 20 54 68 69 | 73 20 63 6f 6d 6d 61 6e |ION: Thi|s comman|
|000026b0| 64 20 64 6f 65 73 20 6e | 6f 74 20 73 61 76 65 20 |d does n|ot save |
|000026c0| 61 6e 79 20 72 65 63 6f | 72 64 73 20 74 68 61 74 |any reco|rds that|
|000026d0| 20 61 72 65 20 6c 6f 63 | 6b 65 64 2e 0d 0d a5 20 | are loc|ked.... |
|000026e0| 47 4f 54 4f ca 52 45 43 | 4f 52 44 3a 20 52 65 63 |GOTO.REC|ORD: Rec|
|000026f0| 6f 72 64 73 20 69 6e 20 | 61 20 6d 75 6c 74 69 2d |ords in |a multi-|
|00002700| 75 73 65 72 20 64 61 74 | 61 62 61 73 65 20 6d 61 |user dat|abase ma|
|00002710| 79 20 62 65 20 64 65 6c | 65 74 65 64 20 61 6e 64 |y be del|eted and|
|00002720| 20 61 64 64 65 64 20 62 | 79 20 6f 74 68 65 72 20 | added b|y other |
|00002730| 75 73 65 72 73 2e 20 49 | 20 74 68 65 72 66 6f 72 |users. I| therfor|
|00002740| 65 20 74 68 65 20 72 65 | 63 6f 72 64 20 6e 75 6d |e the re|cord num|
|00002750| 62 65 72 73 20 6d 61 79 | 20 63 68 61 6e 67 65 2e |bers may| change.|
|00002760| 20 55 73 65 20 63 61 75 | 74 69 6f 6e 20 77 68 65 | Use cau|tion whe|
|00002770| 6e 20 64 69 72 65 63 74 | 6c 79 20 72 65 66 65 72 |n direct|ly refer|
|00002780| 65 6e 63 69 6e 67 20 61 | 20 72 65 63 6f 72 64 20 |encing a| record |
|00002790| 62 79 20 6e 75 6d 62 65 | 72 20 69 6e 20 61 20 6d |by numbe|r in a m|
|000027a0| 75 6c 74 69 2d 75 73 65 | 72 20 64 61 74 61 62 61 |ulti-use|r databa|
|000027b0| 73 65 2e 0d 0d a5 20 53 | 45 54 20 43 4f 4d 4d 41 |se.... S|ET COMMA|
|000027c0| 4e 44 53 3a 20 53 70 65 | 63 69 61 6c 20 63 61 72 |NDS: Spe|cial car|
|000027d0| 65 20 6e 65 65 64 73 20 | 74 6f 20 62 65 20 74 61 |e needs |to be ta|
|000027e0| 6b 65 6e 20 77 69 74 68 | 20 73 65 74 73 20 73 69 |ken with| sets si|
|000027f0| 6e 63 65 20 74 68 65 20 | 69 6e 66 6f 72 6d 61 74 |nce the |informat|
|00002800| 69 6f 6e 20 74 68 61 74 | 20 74 68 65 20 73 65 74 |ion that| the set|
|00002810| 20 77 61 73 20 62 61 73 | 65 64 20 6f 6e 20 6d 61 | was bas|ed on ma|
|00002820| 79 20 62 65 20 63 68 61 | 6e 67 65 64 20 62 79 20 |y be cha|nged by |
|00002830| 61 6e 6f 74 68 65 72 20 | 75 73 65 72 2e 0d 0d 0d |another |user....|
|00002840| 00 00 18 85 55 73 69 6e | 67 ca 54 72 61 6e 73 61 |....Usin|g.Transa|
|00002850| 63 74 69 6f 6e 73 0d 0d | 0d 53 54 41 52 54 ca 54 |ctions..|.START.T|
|00002860| 52 41 4e 53 41 43 54 49 | 4f 4e 0d 43 41 4e 43 45 |RANSACTI|ON.CANCE|
|00002870| 4c ca 54 52 41 4e 53 41 | 43 54 49 4f 4e 0d 56 41 |L.TRANSA|CTION.VA|
|00002880| 4c 49 44 41 54 45 ca 54 | 52 41 4e 53 41 43 54 49 |LIDATE.T|RANSACTI|
|00002890| 4f 4e 0d 0d 0d 54 72 61 | 6e 73 61 63 74 69 6f 6e |ON...Tra|nsaction|
|000028a0| 73 20 61 72 65 20 61 20 | 73 65 72 69 65 73 20 6f |s are a |series o|
|000028b0| 66 20 72 65 6c 61 74 65 | 64 20 64 61 74 61 20 6d |f relate|d data m|
|000028c0| 6f 64 69 66 69 63 61 74 | 69 6f 6e 73 20 74 68 61 |odificat|ions tha|
|000028d0| 74 20 61 72 65 20 6d 61 | 64 65 20 74 6f 20 61 20 |t are ma|de to a |
|000028e0| 64 61 74 61 62 61 73 65 | 2e 20 41 20 74 72 61 6e |database|. A tran|
|000028f0| 73 61 63 74 69 6f 6e 20 | 69 73 20 6e 6f 74 20 73 |saction |is not s|
|00002900| 61 76 65 64 20 70 65 72 | 6d 61 6e 65 6e 74 6c 79 |aved per|manently|
|00002910| 20 74 6f 20 61 20 64 61 | 74 61 62 61 73 65 20 75 | to a da|tabase u|
|00002920| 6e 74 69 6c 20 74 68 65 | 20 74 72 61 6e 73 61 63 |ntil the| transac|
|00002930| 74 69 6f 6e 20 69 73 20 | 76 61 6c 69 64 61 74 65 |tion is |validate|
|00002940| 64 2e 20 49 66 20 61 20 | 74 72 61 6e 73 61 63 74 |d. If a |transact|
|00002950| 69 6f 6e 20 69 73 20 6e | 6f 74 20 63 6f 6d 70 6c |ion is n|ot compl|
|00002960| 65 74 65 64 2c 20 65 69 | 74 68 65 72 20 62 65 63 |eted, ei|ther bec|
|00002970| 61 75 73 65 20 69 74 20 | 69 73 20 63 61 6e 63 65 |ause it |is cance|
|00002980| 6c 6c 65 64 20 6f 72 20 | 62 65 63 61 75 73 65 20 |lled or |because |
|00002990| 6f 66 20 73 6f 6d 65 20 | 6f 75 74 73 69 64 65 20 |of some |outside |
|000029a0| 65 76 65 6e 74 2c 20 74 | 68 65 20 6d 6f 64 69 66 |event, t|he modif|
|000029b0| 69 63 61 74 69 6f 6e 73 | 20 61 72 65 20 6e 6f 74 |ications| are not|
|000029c0| 20 73 61 76 65 64 2e 0d | 0d 44 75 72 69 6e 67 20 | saved..|.During |
|000029d0| 61 20 74 72 61 6e 73 61 | 63 74 69 6f 6e 2c 20 61 |a transa|ction, a|
|000029e0| 6c 6c 20 63 68 61 6e 67 | 65 73 20 74 6f 20 74 68 |ll chang|es to th|
|000029f0| 65 20 64 61 74 61 20 6f | 66 20 61 20 64 61 74 61 |e data o|f a data|
|00002a00| 62 61 73 65 20 61 72 65 | 20 73 74 6f 72 65 64 20 |base are| stored |
|00002a10| 6c 6f 63 61 6c 6c 79 20 | 69 6e 20 61 20 74 65 6d |locally |in a tem|
|00002a20| 70 6f 72 61 72 79 20 62 | 75 66 66 65 72 2e 20 49 |porary b|uffer. I|
|00002a30| 66 20 74 68 65 20 74 72 | 61 6e 73 61 63 74 69 6f |f the tr|ansactio|
|00002a40| 6e 20 69 73 20 61 63 63 | 65 70 74 65 64 20 77 69 |n is acc|epted wi|
|00002a50| 74 68 20 56 41 4c 49 44 | 41 54 45 ca 54 52 41 4e |th VALID|ATE.TRAN|
|00002a60| 53 41 43 54 49 4f 4e 2c | 20 74 68 65 20 63 68 61 |SACTION,| the cha|
|00002a70| 6e 67 65 73 20 61 72 65 | 20 73 61 76 65 64 20 70 |nges are| saved p|
|00002a80| 65 72 6d 61 6e 65 6e 74 | 6c 79 2e 20 49 66 20 74 |ermanent|ly. If t|
|00002a90| 68 65 20 74 72 61 6e 73 | 61 63 74 69 6f 6e 20 69 |he trans|action i|
|00002aa0| 73 20 63 61 6e 63 65 6c | 6c 65 64 20 77 69 74 68 |s cancel|led with|
|00002ab0| 20 43 41 4e 43 45 4c ca | 54 52 41 4e 53 41 43 54 | CANCEL.|TRANSACT|
|00002ac0| 49 4f 4e 2c 20 74 68 65 | 20 63 68 61 6e 67 65 73 |ION, the| changes|
|00002ad0| 20 61 72 65 20 6e 6f 74 | 20 73 61 76 65 64 2e 0d | are not| saved..|
|00002ae0| 0d 41 66 74 65 72 20 61 | 20 74 72 61 6e 73 61 63 |.After a| transac|
|00002af0| 74 69 6f 6e 20 69 73 20 | 76 61 6c 69 64 61 74 65 |tion is |validate|
|00002b00| 64 20 6f 72 20 63 61 6e | 63 65 6c 6c 65 64 2c 20 |d or can|celled, |
|00002b10| 74 68 65 20 73 65 6c 65 | 63 74 69 6f 6e 20 6f 66 |the sele|ction of|
|00002b20| 20 65 61 63 68 20 66 69 | 6c 65 20 66 6f 72 20 74 | each fi|le for t|
|00002b30| 68 65 20 63 75 72 72 65 | 6e 74 20 70 72 6f 63 65 |he curre|nt proce|
|00002b40| 73 73 20 62 65 63 6f 6d | 65 73 20 65 6d 70 74 79 |ss becom|es empty|
|00002b50| 20 62 65 63 61 75 73 65 | 20 74 72 61 6e 73 61 63 | because| transac|
|00002b60| 74 69 6f 6e 73 20 64 65 | 61 6c 20 77 69 74 68 20 |tions de|al with |
|00002b70| 74 65 6d 70 6f 72 61 72 | 79 20 72 65 63 6f 72 64 |temporar|y record|
|00002b80| 20 61 64 64 72 65 73 73 | 65 73 2e 20 46 6f 72 20 | address|es. For |
|00002b90| 74 68 65 20 73 61 6d 65 | 20 72 65 61 73 6f 6e 20 |the same| reason |
|00002ba0| 79 6f 75 20 73 68 6f 75 | 6c 64 20 62 65 20 63 61 |you shou|ld be ca|
|00002bb0| 75 74 69 6f 75 73 20 77 | 68 65 6e 20 75 73 69 6e |utious w|hen usin|
|00002bc0| 67 20 6e 61 6d 65 64 20 | 73 65 6c 65 63 74 69 6f |g named |selectio|
|00002bd0| 6e 73 20 69 6e 73 69 64 | 65 20 61 20 74 72 61 6e |ns insid|e a tran|
|00002be0| 73 61 63 74 69 6f 6e 2e | 20 41 66 74 65 72 20 61 |saction.| After a|
|00002bf0| 20 74 72 61 6e 73 61 63 | 74 69 6f 6e 20 69 73 20 | transac|tion is |
|00002c00| 76 61 6c 69 64 61 74 65 | 64 20 6f 72 20 63 61 6e |validate|d or can|
|00002c10| 63 65 6c 6c 65 64 2c 20 | 61 20 6e 61 6d 65 64 20 |celled, |a named |
|00002c20| 73 65 6c 65 63 74 69 6f | 6e 20 63 72 65 61 74 65 |selectio|n create|
|00002c30| 64 20 62 65 66 6f 72 65 | 20 6f 72 20 64 75 72 69 |d before| or duri|
|00002c40| 6e 67 20 74 68 65 20 74 | 72 61 6e 73 61 63 74 69 |ng the t|ransacti|
|00002c50| 6f 6e 20 6d 61 79 20 63 | 6f 6e 74 61 69 6e 20 69 |on may c|ontain i|
|00002c60| 6e 63 6f 72 72 65 63 74 | 20 72 65 63 6f 72 64 20 |ncorrect| record |
|00002c70| 61 64 64 72 65 73 73 65 | 73 2e 20 46 6f 72 20 69 |addresse|s. For i|
|00002c80| 6e 73 74 61 6e 63 65 2c | 20 61 20 6e 61 6d 65 64 |nstance,| a named|
|00002c90| 20 73 65 6c 65 63 74 69 | 6f 6e 20 6d 61 79 20 63 | selecti|on may c|
|00002ca0| 6f 6e 74 61 69 6e 20 74 | 68 65 20 61 64 64 72 65 |ontain t|he addre|
|00002cb0| 73 73 20 6f 66 20 61 20 | 64 65 6c 65 74 65 64 20 |ss of a |deleted |
|00002cc0| 72 65 63 6f 72 64 20 6f | 72 20 74 68 65 20 74 65 |record o|r the te|
|00002cd0| 6d 70 6f 72 61 72 79 20 | 61 64 64 72 65 73 73 20 |mporary |address |
|00002ce0| 6f 66 20 61 20 72 65 63 | 6f 72 64 20 61 64 64 65 |of a rec|ord adde|
|00002cf0| 64 20 64 75 72 69 6e 67 | 20 74 68 65 20 74 72 61 |d during| the tra|
|00002d00| 6e 73 61 63 74 69 6f 6e | 2e 0d 0d 54 68 69 73 20 |nsaction|...This |
|00002d10| 61 70 70 6c 69 65 73 20 | 74 6f 20 73 65 74 73 20 |applies |to sets |
|00002d20| 61 6c 73 6f 20 62 65 63 | 61 75 73 65 20 74 68 65 |also bec|ause the|
|00002d30| 79 20 61 72 65 20 62 61 | 73 65 64 20 6f 6e 20 62 |y are ba|sed on b|
|00002d40| 69 74 20 74 61 62 6c 65 | 73 20 77 69 74 68 20 72 |it table|s with r|
|00002d50| 65 63 6f 72 64 20 61 64 | 64 72 65 73 73 65 73 2e |ecord ad|dresses.|
|00002d60| 0d 0d 0d 54 72 61 6e 73 | 61 63 74 69 6f 6e 20 45 |...Trans|action E|
|00002d70| 78 61 6d 70 6c 65 0d 0d | 54 68 65 20 65 78 61 6d |xample..|The exam|
|00002d80| 70 6c 65 20 69 6e 20 74 | 68 69 73 20 73 65 63 74 |ple in t|his sect|
|00002d90| 69 6f 6e 20 69 73 20 62 | 61 73 65 64 20 6f 6e 20 |ion is b|ased on |
|00002da0| 74 68 65 20 64 61 74 61 | 62 61 73 65 20 73 74 72 |the data|base str|
|00002db0| 75 63 74 75 72 65 20 73 | 68 6f 77 6e 20 62 65 6c |ucture s|hown bel|
|00002dc0| 6f 77 2e 20 54 68 65 20 | 64 61 74 61 62 61 73 65 |ow. The |database|
|00002dd0| 20 69 73 20 61 20 73 69 | 6d 70 6c 65 20 69 6e 76 | is a si|mple inv|
|00002de0| 6f 69 63 69 6e 67 20 73 | 79 73 74 65 6d 2e 20 54 |oicing s|ystem. T|
|00002df0| 68 65 20 69 6e 76 6f 69 | 63 65 20 6c 69 6e 65 73 |he invoi|ce lines|
|00002e00| 20 61 72 65 20 73 74 6f | 72 65 64 20 69 6e 20 61 | are sto|red in a|
|00002e10| 20 66 69 6c 65 20 63 61 | 6c 6c 65 64 20 5b 49 6e | file ca|lled [In|
|00002e20| 76 6f 69 63 65 20 4c 69 | 6e 65 73 5d 20 77 68 69 |voice Li|nes] whi|
|00002e30| 63 68 20 69 73 20 72 65 | 6c 61 74 65 64 20 74 6f |ch is re|lated to|
|00002e40| 20 74 68 65 20 66 69 6c | 65 20 5b 49 6e 76 6f 69 | the fil|e [Invoi|
|00002e50| 63 65 73 5d 20 62 79 20 | 74 68 65 20 6d 65 61 6e |ces] by |the mean|
|00002e60| 73 20 6f 66 20 61 20 72 | 65 6c 61 74 69 6f 6e 20 |s of a r|elation |
|00002e70| 62 65 74 77 65 65 6e 20 | 74 68 65 20 66 69 65 6c |between |the fiel|
|00002e80| 64 73 20 5b 49 6e 76 6f | 69 63 65 73 5d 49 6e 76 |ds [Invo|ices]Inv|
|00002e90| 6f 69 63 65 20 49 44 20 | 61 6e 64 20 5b 49 6e 76 |oice ID |and [Inv|
|00002ea0| 6f 69 63 65 20 4c 69 6e | 65 73 5d 49 6e 76 6f 69 |oice Lin|es]Invoi|
|00002eb0| 63 65 20 49 44 2e 20 57 | 68 65 6e 20 61 6e 20 69 |ce ID. W|hen an i|
|00002ec0| 6e 76 6f 69 63 65 20 69 | 73 20 61 64 64 65 64 2c |nvoice i|s added,|
|00002ed0| 20 61 20 75 6e 69 71 75 | 65 20 49 44 20 69 73 20 | a uniqu|e ID is |
|00002ee0| 63 61 6c 63 75 6c 61 74 | 65 64 20 75 73 69 6e 67 |calculat|ed using|
|00002ef0| 20 74 68 65 20 53 65 71 | 75 65 6e 63 65 ca 6e 75 | the Seq|uence.nu|
|00002f00| 6d 62 65 72 20 63 6f 6d | 6d 61 6e 64 2e 20 54 68 |mber com|mand. Th|
|00002f10| 65 20 72 65 6c 61 74 69 | 6f 6e 20 62 65 74 77 65 |e relati|on betwe|
|00002f20| 65 6e 20 5b 49 6e 76 6f | 69 63 65 73 5d 20 61 6e |en [Invo|ices] an|
|00002f30| 64 20 5b 49 6e 76 6f 69 | 63 65 73 20 4c 69 6e 65 |d [Invoi|ces Line|
|00002f40| 73 5d 20 69 73 20 61 6e | 20 61 75 74 6f 6d 61 74 |s] is an| automat|
|00002f50| 69 63 20 52 65 6c 61 74 | 65 20 6d 61 6e 79 20 72 |ic Relat|e many r|
|00002f60| 65 6c 61 74 69 6f 6e 2e | 20 54 68 65 20 41 75 74 |elation.| The Aut|
|00002f70| 6f 20 41 73 73 69 67 6e | 20 52 65 6c 61 74 65 64 |o Assign| Related|
|00002f80| 20 56 61 6c 75 65 20 63 | 68 65 63 6b 20 62 6f 78 | Value c|heck box|
|00002f90| 20 69 73 20 63 68 65 63 | 6b 65 64 2e 0d 0d 54 68 | is chec|ked...Th|
|00002fa0| 65 20 72 65 6c 61 74 69 | 6f 6e 20 62 65 74 77 65 |e relati|on betwe|
|00002fb0| 65 6e 20 5b 49 6e 76 6f | 69 63 65 20 4c 69 6e 65 |en [Invo|ice Line|
|00002fc0| 73 5d 20 61 6e 64 20 5b | 50 61 72 74 73 5d 20 69 |s] and [|Parts] i|
|00002fd0| 73 20 6d 61 6e 75 61 6c | 2e 0d 0d 57 68 65 6e 20 |s manual|...When |
|00002fe0| 61 20 75 73 65 72 20 65 | 6e 74 65 72 73 20 61 6e |a user e|nters an|
|00002ff0| 20 69 6e 76 6f 69 63 65 | 2c 20 74 68 65 20 66 6f | invoice|, the fo|
|00003000| 6c 6c 6f 77 69 6e 67 20 | 61 63 74 69 6f 6e 73 20 |llowing |actions |
|00003010| 68 61 76 65 20 74 6f 20 | 62 65 20 65 78 65 63 75 |have to |be execu|
|00003020| 74 65 64 3a 0d 0d a5 20 | 41 64 64 20 61 20 72 65 |ted:... |Add a re|
|00003030| 63 6f 72 64 20 69 6e 20 | 74 68 65 20 66 69 6c 65 |cord in |the file|
|00003040| 20 5b 49 6e 76 6f 69 63 | 65 73 5d 2e 0d 0d a5 20 | [Invoic|es].... |
|00003050| 41 64 64 20 73 65 76 65 | 72 61 6c 20 72 65 63 6f |Add seve|ral reco|
|00003060| 72 64 73 20 69 6e 20 74 | 68 65 20 66 69 6c 65 20 |rds in t|he file |
|00003070| 5b 49 6e 76 6f 69 63 65 | 20 4c 69 6e 65 73 5d 2e |[Invoice| Lines].|
|00003080| 0d 0d a5 20 55 70 64 61 | 74 65 20 74 68 65 20 5b |... Upda|te the [|
|00003090| 50 61 72 74 73 5d 6c 6e | 20 57 61 72 65 68 6f 75 |Parts]ln| Warehou|
|000030a0| 73 65 20 66 69 65 6c 64 | 20 6f 66 20 65 61 63 68 |se field| of each|
|000030b0| 20 70 61 72 74 20 6c 69 | 73 74 65 64 20 69 6e 20 | part li|sted in |
|000030c0| 74 68 65 20 69 6e 76 6f | 69 63 65 2e 0d 0d 0d 49 |the invo|ice....I|
|000030d0| 6e 20 6f 74 68 65 72 20 | 77 6f 72 64 73 2c 20 79 |n other |words, y|
|000030e0| 6f 75 20 6e 65 65 64 20 | 74 6f 20 73 61 76 65 20 |ou need |to save |
|000030f0| 72 65 6c 61 74 65 64 20 | 64 61 74 61 2e 20 49 74 |related |data. It|
|00003100| 20 69 73 20 61 20 74 79 | 70 69 63 61 6c 20 73 69 | is a ty|pical si|
|00003110| 74 75 61 74 69 6f 6e 20 | 77 68 65 72 65 20 79 6f |tuation |where yo|
|00003120| 75 20 6e 65 65 64 20 74 | 6f 20 75 73 65 20 61 20 |u need t|o use a |
|00003130| 74 72 61 6e 73 61 63 74 | 69 6f 6e 2e 0d 0d 59 6f |transact|ion...Yo|
|00003140| 75 20 6e 65 65 64 20 74 | 6f 20 62 65 20 73 75 72 |u need t|o be sur|
|00003150| 65 20 74 68 61 74 20 79 | 6f 75 20 63 61 6e 20 73 |e that y|ou can s|
|00003160| 61 76 65 20 61 6c 6c 20 | 74 68 65 73 65 20 72 65 |ave all |these re|
|00003170| 63 6f 72 64 73 20 64 75 | 72 69 6e 67 20 74 68 65 |cords du|ring the|
|00003180| 20 6f 70 65 72 61 74 69 | 6f 6e 20 6f 72 20 74 6f | operati|on or to|
|00003190| 20 62 65 20 61 62 6c 65 | 20 74 6f 20 63 61 6e 63 | be able| to canc|
|000031a0| 65 6c 20 74 68 65 20 74 | 72 61 6e 73 61 63 74 69 |el the t|ransacti|
|000031b0| 6f 6e 20 69 66 20 61 20 | 72 65 63 6f 72 64 20 63 |on if a |record c|
|000031c0| 61 6e 6e 6f 74 20 62 65 | 20 61 64 64 65 64 20 6f |annot be| added o|
|000031d0| 72 20 75 70 64 61 74 65 | 64 2e 0d 0d 49 66 20 79 |r update|d...If y|
|000031e0| 6f 75 20 64 6f 20 6e 6f | 74 20 75 73 65 20 61 20 |ou do no|t use a |
|000031f0| 74 72 61 6e 73 61 63 74 | 69 6f 6e 2c 20 79 6f 75 |transact|ion, you|
|00003200| 20 63 61 6e 6e 6f 74 20 | 67 75 61 72 61 6e 74 65 | cannot |guarante|
|00003210| 65 20 74 68 65 20 6c 6f | 67 69 63 61 6c 20 64 61 |e the lo|gical da|
|00003220| 74 61 20 69 6e 74 65 67 | 72 69 74 79 20 6f 66 20 |ta integ|rity of |
|00003230| 79 6f 75 72 20 64 61 74 | 61 62 61 73 65 2e 20 46 |your dat|abase. F|
|00003240| 6f 72 20 69 6e 73 74 61 | 6e 63 65 2c 20 69 66 20 |or insta|nce, if |
|00003250| 6f 6e 65 20 72 65 63 6f | 72 64 20 6f 66 20 74 68 |one reco|rd of th|
|00003260| 65 20 5b 50 61 72 74 73 | 5d 20 72 65 63 6f 72 64 |e [Parts|] record|
|00003270| 73 20 69 73 20 6c 6f 63 | 6b 65 64 20 79 6f 75 20 |s is loc|ked you |
|00003280| 77 69 6c 6c 20 6e 6f 74 | 20 62 65 20 61 62 6c 65 |will not| be able|
|00003290| 20 74 6f 20 75 70 64 61 | 74 65 20 74 68 65 20 71 | to upda|te the q|
|000032a0| 75 61 6e 74 69 74 79 20 | 73 74 6f 72 65 64 20 69 |uantity |stored i|
|000032b0| 6e 20 74 68 65 20 66 69 | 65 6c 64 20 5b 50 61 72 |n the fi|eld [Par|
|000032c0| 74 73 5d 49 6e 20 57 61 | 72 65 68 6f 75 73 65 2e |ts]In Wa|rehouse.|
|000032d0| 20 54 68 65 72 65 66 6f | 72 65 20 74 68 69 73 20 | Therefo|re this |
|000032e0| 66 69 65 6c 64 20 77 69 | 6c 6c 20 62 65 63 6f 6d |field wi|ll becom|
|000032f0| 65 20 6c 6f 67 69 63 61 | 6c 6c 79 20 69 6e 63 6f |e logica|lly inco|
|00003300| 72 72 65 63 74 2e 20 54 | 68 65 20 73 75 6d 20 6f |rrect. T|he sum o|
|00003310| 66 20 74 68 65 20 70 61 | 72 74 73 20 73 6f 6c 64 |f the pa|rts sold|
|00003320| 20 61 6e 64 20 74 68 65 | 20 70 61 72 74 73 20 72 | and the| parts r|
|00003330| 65 6d 61 69 6e 69 6e 67 | 20 69 6e 20 74 68 65 20 |emaining| in the |
|00003340| 77 61 72 65 68 6f 75 73 | 65 20 77 69 6c 6c 20 6e |warehous|e will n|
|00003350| 6f 74 20 62 65 20 65 71 | 75 61 6c 20 74 6f 20 74 |ot be eq|ual to t|
|00003360| 68 65 20 6f 72 69 67 69 | 6e 61 6c 20 71 75 61 6e |he origi|nal quan|
|00003370| 74 69 74 79 20 65 6e 74 | 65 72 65 64 20 69 6e 20 |tity ent|ered in |
|00003380| 74 68 65 20 72 65 63 6f | 72 64 2e 20 59 6f 75 20 |the reco|rd. You |
|00003390| 63 61 6e 20 61 76 6f 69 | 64 20 73 75 63 68 20 61 |can avoi|d such a|
|000033a0| 20 73 69 74 75 61 74 69 | 6f 6e 20 62 79 20 75 73 | situati|on by us|
|000033b0| 69 6e 67 20 74 72 61 6e | 73 61 63 74 69 6f 6e 73 |ing tran|sactions|
|000033c0| 2e 0d 0d 0d 54 68 65 20 | 6c 61 79 6f 75 74 20 68 |....The |layout h|
|000033d0| 61 73 20 74 77 6f 20 62 | 75 74 74 6f 6e 73 3a 20 |as two b|uttons: |
|000033e0| 62 43 61 6e 63 65 6c 20 | 61 6e 64 20 62 4f 4b 2e |bCancel |and bOK.|
|000033f0| 20 42 6f 74 68 20 62 75 | 74 74 6f 6e 73 20 61 72 | Both bu|ttons ar|
|00003400| 65 20 6e 6f 20 61 63 74 | 69 6f 6e 20 62 75 74 74 |e no act|ion butt|
|00003410| 6f 6e 73 20 61 6e 64 20 | 61 72 65 20 6d 61 6e 61 |ons and |are mana|
|00003420| 67 65 64 20 69 6e 20 74 | 68 65 20 6c 61 79 6f 75 |ged in t|he layou|
|00003430| 74 20 70 72 6f 63 65 64 | 75 72 65 2e 0d 0d 54 68 |t proced|ure...Th|
|00003440| 65 20 70 72 6f 63 65 64 | 75 72 65 20 62 65 6c 6f |e proced|ure belo|
|00003450| 77 20 73 65 74 73 20 74 | 68 65 20 72 65 61 64 2d |w sets t|he read-|
|00003460| 77 72 69 74 65 2f 72 65 | 61 64 2d 6f 6e 6c 79 20 |write/re|ad-only |
|00003470| 73 74 61 74 65 73 20 66 | 6f 72 20 74 68 65 20 66 |states f|or the f|
|00003480| 69 6c 65 73 2e 20 54 68 | 65 6e 20 69 74 20 63 72 |iles. Th|en it cr|
|00003490| 65 61 74 65 73 20 61 20 | 6c 6f 6f 70 20 74 6f 20 |eates a |loop to |
|000034a0| 61 64 64 20 6e 65 77 20 | 72 65 63 6f 72 64 73 3a |add new |records:|
|000034b0| 0d 0d 52 45 41 44 20 4f | 4e 4c 59 28 5b 49 6e 76 |..READ O|NLY([Inv|
|000034c0| 6f 69 63 65 73 5d 29 20 | 20 20 20 20 20 20 20 20 |oices]) | |
|000034d0| 20 20 20 20 20 60 20 53 | 65 74 20 74 68 65 20 73 | ` S|et the s|
|000034e0| 74 61 74 65 20 66 6f 72 | 20 74 68 65 20 66 69 6c |tate for| the fil|
|000034f0| 65 0d 52 45 41 44 20 57 | 52 49 54 45 28 5b 49 6e |e.READ W|RITE([In|
|00003500| 76 6f 69 63 65 73 20 4c | 69 6e 65 73 5d 29 20 20 |voices L|ines]) |
|00003510| 20 20 20 60 20 53 65 74 | 20 72 65 61 64 2d 77 72 | ` Set| read-wr|
|00003520| 69 74 65 20 66 6f 72 20 | 74 68 69 73 20 66 69 6c |ite for |this fil|
|00003530| 65 0d 52 45 41 44 20 4f | 4e 4c 59 28 5b 50 61 72 |e.READ O|NLY([Par|
|00003540| 74 73 5d 29 20 20 20 20 | 20 20 20 20 20 20 20 20 |ts]) | |
|00003550| 20 20 20 20 20 20 60 20 | 53 65 74 20 72 65 61 64 | ` |Set read|
|00003560| 2d 6f 6e 6c 79 20 66 6f | 72 20 74 68 69 73 20 66 |-only fo|r this f|
|00003570| 69 6c 65 0d 49 4e 50 55 | 54 20 4c 41 59 4f 55 54 |ile.INPU|T LAYOUT|
|00003580| 28 5b 49 6e 76 6f 69 63 | 65 73 5d 3b 22 49 6e 70 |([Invoic|es];"Inp|
|00003590| 75 74 22 29 20 20 20 60 | 20 53 65 6c 65 63 74 20 |ut") `| Select |
|000035a0| 74 68 65 20 67 6f 6f 64 | 20 6c 61 79 6f 75 74 0d |the good| layout.|
|000035b0| 52 65 70 65 61 74 0d 20 | 20 20 20 41 44 44 20 52 |Repeat. | ADD R|
|000035c0| 45 43 4f 52 44 28 5b 49 | 6e 76 6f 69 63 65 73 5d |ECORD([I|nvoices]|
|000035d0| 29 20 20 20 20 20 20 60 | 20 41 64 64 20 61 73 20 |) `| Add as |
|000035e0| 6d 61 6e 79 20 72 65 63 | 6f 72 64 73 20 61 73 20 |many rec|ords as |
|000035f0| 72 65 71 75 69 72 65 64 | 0d 55 6e 74 69 6c 20 28 |required|.Until (|
|00003600| 62 4f 4b 3d 30 29 0d 52 | 45 41 44 20 4f 4e 4c 59 |bOK=0).R|EAD ONLY|
|00003610| 28 5b 49 6e 76 6f 69 63 | 65 20 4c 69 6e 65 73 5d |([Invoic|e Lines]|
|00003620| 29 20 20 20 20 20 60 20 | 53 65 74 20 74 68 65 20 |) ` |Set the |
|00003630| 73 74 61 74 65 20 66 6f | 72 20 74 68 65 20 66 69 |state fo|r the fi|
|00003640| 6c 65 73 0d 0d 0d 0d 0d | 54 68 65 20 74 72 61 6e |les.....|The tran|
|00003650| 73 61 63 74 69 6f 6e 20 | 69 73 20 6d 61 6e 61 67 |saction |is manag|
|00003660| 65 64 20 69 6e 20 74 68 | 65 20 6c 61 79 6f 75 74 |ed in th|e layout|
|00003670| 20 70 72 6f 63 65 64 75 | 72 65 20 6c 69 73 74 65 | procedu|re liste|
|00003680| 64 20 62 65 6c 6f 77 3a | 0d 0d 43 61 73 65 20 6f |d below:|..Case o|
|00003690| 66 0d 20 20 3a 20 28 42 | 65 66 6f 72 65 29 20 20 |f. : (B|efore) |
|000036a0| 20 20 20 20 20 20 20 20 | 60 20 42 65 66 6f 72 65 | |` Before|
|000036b0| 20 74 68 65 20 6c 61 79 | 6f 75 74 20 61 70 70 65 | the lay|out appe|
|000036c0| 61 72 73 0d 20 20 20 20 | 20 20 20 20 53 54 41 52 |ars. | STAR|
|000036d0| 54 20 54 52 41 4e 53 41 | 43 54 49 4f 4e 20 20 20 |T TRANSA|CTION |
|000036e0| 60 20 42 65 66 6f 72 65 | 20 64 61 74 61 20 65 6e |` Before| data en|
|000036f0| 74 72 79 20 73 74 61 72 | 74 20 74 72 61 6e 73 61 |try star|t transa|
|00003700| 63 74 69 6f 6e 0d 20 20 | 20 20 20 20 20 20 5b 49 |ction. | [I|
|00003710| 6e 76 6f 69 63 65 73 5d | 49 6e 76 6f 69 63 65 20 |nvoices]|Invoice |
|00003720| 49 44 3a 3d 53 65 71 75 | 65 6e 63 65 20 6e 75 6d |ID:=Sequ|ence num|
|00003730| 62 65 72 28 5b 49 6e 76 | 6f 69 63 65 73 5d 49 6e |ber([Inv|oices]In|
|00003740| 76 6f 69 63 65 20 49 44 | 29 0d 0d 20 20 20 3a 20 |voice ID|).. : |
|00003750| 28 44 75 72 69 6e 67 29 | 20 20 20 20 20 20 20 20 |(During)| |
|00003760| 20 20 20 20 20 20 20 20 | 20 60 20 44 75 72 69 6e | | ` Durin|
|00003770| 67 20 74 68 65 20 64 61 | 74 61 20 65 6e 74 72 79 |g the da|ta entry|
|00003780| 0d 20 20 20 20 20 20 20 | 20 5b 49 6e 76 6f 69 63 |. | [Invoic|
|00003790| 65 73 5d 54 6f 74 61 6c | 20 49 6e 76 6f 69 63 65 |es]Total| Invoice|
|000037a0| 3a 3d 53 75 6d 28 5b 49 | 6e 76 6f 69 63 65 20 4c |:=Sum([I|nvoice L|
|000037b0| 69 6e 65 73 5d 54 6f 74 | 61 6c 20 6c 69 6e 65 29 |ines]Tot|al line)|
|000037c0| 0d 0d 20 20 20 20 20 20 | 20 20 43 61 73 65 20 6f |.. | Case o|
|000037d0| 66 0d 20 20 20 20 20 20 | 20 20 20 3a 28 62 43 61 |f. | :(bCa|
|000037e0| 6e 63 65 6c 3d 31 29 20 | 20 20 20 20 20 60 20 59 |ncel=1) | ` Y|
|000037f0| 6f 75 20 63 6c 69 63 6b | 65 64 20 6f 6e 20 43 61 |ou click|ed on Ca|
|00003800| 6e 63 65 6c 0d 20 20 20 | 20 20 20 20 20 20 20 20 |ncel. | |
|00003810| 20 20 20 43 41 4e 43 45 | 4c 20 54 52 41 4e 53 41 | CANCE|L TRANSA|
|00003820| 43 54 49 4f 4e 20 20 20 | 20 20 20 60 20 43 61 6e |CTION | ` Can|
|00003830| 63 65 6c 20 65 76 65 72 | 79 74 68 69 6e 67 0d 20 |cel ever|ything. |
|00003840| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 43 41 4e | | CAN|
|00003850| 43 45 4c 20 20 20 20 60 | 20 4c 65 61 76 65 20 74 |CEL `| Leave t|
|00003860| 68 65 20 6c 61 79 6f 75 | 74 0d 20 20 0d 20 20 20 |he layou|t. . |
|00003870| 20 20 20 20 20 20 3a 28 | 62 56 61 6c 69 64 61 74 | :(|bValidat|
|00003880| 65 3d 31 29 20 20 20 60 | 20 20 59 6f 75 20 63 6c |e=1) `| You cl|
|00003890| 69 63 6b 65 64 20 6f 6e | 20 76 61 6c 69 64 61 74 |icked on| validat|
|000038a0| 65 0d 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |e. | |
|000038b0| 20 24 4e 62 4c 69 6e 65 | 73 3a 3d 52 65 63 6f 72 | $NbLine|s:=Recor|
|000038c0| 64 73 20 69 6e 20 73 65 | 6c 65 63 74 69 6f 6e 28 |ds in se|lection(|
|000038d0| 5b 49 6e 76 6f 69 63 65 | 20 4c 69 6e 65 73 5d 29 |[Invoice| Lines])|
|000038e0| 0d 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|000038f0| 52 45 41 44 20 57 52 49 | 54 45 28 5b 50 61 72 74 |READ WRI|TE([Part|
|00003900| 73 5d 29 20 20 20 20 20 | 20 20 20 20 20 60 20 20 |s]) | ` |
|00003910| 55 70 64 61 74 65 20 50 | 61 72 74 73 0d 20 20 20 |Update P|arts. |
|00003920| 20 20 20 20 20 20 20 20 | 20 20 20 20 46 49 52 53 | | FIRS|
|00003930| 54 20 52 45 43 4f 52 44 | 28 5b 49 6e 76 6f 69 63 |T RECORD|([Invoic|
|00003940| 65 20 4c 69 6e 65 73 5d | 29 20 20 20 20 20 20 20 |e Lines]|) |
|00003950| 60 20 53 74 61 72 74 20 | 61 74 20 74 68 65 20 66 |` Start |at the f|
|00003960| 69 72 73 74 20 6c 69 6e | 65 0d 20 20 20 20 20 20 |irst lin|e. |
|00003970| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003980| 20 20 20 20 20 20 20 60 | 20 41 73 73 75 6d 65 20 | `| Assume |
|00003990| 65 76 65 72 79 74 68 69 | 6e 67 20 77 69 6c 6c 20 |everythi|ng will |
|000039a0| 62 65 20 4f 4b 0d 0d 20 | 20 20 20 20 20 20 20 20 |be OK.. | |
|000039b0| 20 20 20 20 20 20 46 6f | 72 20 28 24 4c 69 6e 65 | Fo|r ($Line|
|000039c0| 3b 20 31 20 3b 24 4e 62 | 4c 69 6e 65 73 29 20 20 |; 1 ;$Nb|Lines) |
|000039d0| 20 20 20 20 20 20 20 20 | 20 20 60 20 20 46 6f 72 | | ` For|
|000039e0| 20 65 61 63 68 20 6c 69 | 6e 65 0d 20 20 20 20 20 | each li|ne. |
|000039f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 52 45 4c | | REL|
|00003a00| 41 54 45 20 4f 4e 45 28 | 5b 49 6e 76 6f 69 63 65 |ATE ONE(|[Invoice|
|00003a10| 20 4c 69 6e 65 73 5d 50 | 61 72 74 20 4e 6f 29 0d | Lines]P|art No).|
|00003a20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003a30| 20 20 4f 4b 3a 3d 31 20 | 20 20 20 20 20 20 20 20 | OK:=1 | |
|00003a40| 20 20 20 20 20 20 60 20 | 20 41 73 73 75 6d 65 20 | ` | Assume |
|00003a50| 79 6f 75 20 77 61 6e 74 | 20 74 6f 20 63 6f 6e 74 |you want| to cont|
|00003a60| 69 6e 75 65 0d 0d 20 20 | 20 20 20 20 20 20 20 20 |inue.. | |
|00003a70| 20 20 20 20 20 20 20 20 | 57 68 69 6c 65 20 28 4c | |While (L|
|00003a80| 6f 63 6b 65 64 28 5b 50 | 61 72 74 73 5d 29 20 26 |ocked([P|arts]) &|
|00003a90| 20 28 4f 4b 3d 31 20 29 | 29 0d 20 20 20 20 20 20 | (OK=1 )|). |
|00003aa0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 43 | | C|
|00003ab0| 4f 4e 46 6c 52 4d 28 22 | 54 68 65 20 50 61 72 74 |ONFlRM("|The Part|
|00003ac0| 20 22 2b 5b 49 6e 76 6f | 69 63 65 20 4c 69 6e 65 | "+[Invo|ice Line|
|00003ad0| 73 5d 50 61 72 74 20 4e | 6f 2b 22 20 69 73 20 69 |s]Part N|o+" is i|
|00003ae0| 6e 20 0d 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |n . | |
|00003af0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003b00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003b10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003b20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003b30| 20 20 20 20 20 20 20 20 | 20 20 20 20 75 73 65 2e | | use.|
|00003b40| 20 57 61 69 74 3f 22 29 | 0d 20 20 20 20 20 20 20 | Wait?")|. |
|00003b50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 49 66 | | If|
|00003b60| 20 28 4f 4b 3d 31 29 0d | 20 20 20 20 20 20 20 20 | (OK=1).| |
|00003b70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003b80| 44 45 4c 41 59 20 50 52 | 4f 43 45 53 53 28 43 75 |DELAY PR|OCESS(Cu|
|00003b90| 72 72 65 6e 74 20 70 72 | 6f 63 65 73 73 3b 36 30 |rrent pr|ocess;60|
|00003ba0| 29 0d 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |). | |
|00003bb0| 20 20 20 20 4c 4f 41 44 | 20 52 45 43 4f 52 44 28 | LOAD| RECORD(|
|00003bc0| 5b 50 61 72 74 73 5d 29 | 20 20 20 60 20 54 72 79 |[Parts])| ` Try|
|00003bd0| 20 74 6f 20 6c 6f 61 64 | 20 74 68 65 20 72 65 63 | to load| the rec|
|00003be0| 6f 72 64 0d 20 20 20 20 | 20 20 20 20 20 20 20 20 |ord. | |
|00003bf0| 20 20 20 20 20 20 20 20 | 45 6e 64 20 69 66 0d 20 | |End if. |
|00003c00| 20 20 20 20 20 20 20 20 | 20 20 20 20 45 6e 64 20 | | End |
|00003c10| 77 68 69 6c 65 0d 0d 20 | 20 20 20 20 20 20 20 20 |while.. | |
|00003c20| 20 20 20 20 20 20 20 20 | 49 66 20 28 4f 4b 3d 31 | |If (OK=1|
|00003c30| 29 0d 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |). | |
|00003c40| 20 20 20 20 20 5b 50 61 | 72 74 73 5d 49 6e 20 57 | [Pa|rts]In W|
|00003c50| 61 72 65 68 6f 75 73 65 | 3a 3d 5b 50 61 72 74 73 |arehouse|:=[Parts|
|00003c60| 5d 49 6e 20 57 61 72 65 | 68 6f 75 73 65 2d 5b 6c |]In Ware|house-[l|
|00003c70| 6e 76 6f 69 63 65 20 0d | 20 20 20 20 20 20 20 20 |nvoice .| |
|00003c80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003c90| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003ca0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003cb0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003cc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 4c | | L|
|00003cd0| 69 6e 65 73 5d 51 75 61 | 6e 74 69 74 79 0d 20 20 |ines]Qua|ntity. |
|00003ce0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003cf0| 20 20 20 20 20 20 60 20 | 20 55 70 64 61 74 65 20 | ` | Update |
|00003d00| 71 75 61 6e 74 69 74 79 | 20 69 6e 20 74 68 65 20 |quantity| in the |
|00003d10| 77 61 72 65 68 6f 75 73 | 65 0d 20 20 20 20 20 20 |warehous|e. |
|00003d20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 53 41 56 | | SAV|
|00003d30| 45 20 52 45 43 4f 52 44 | 28 5b 50 61 72 74 73 5d |E RECORD|([Parts]|
|00003d40| 29 20 20 20 20 20 20 20 | 60 20 20 53 61 76 65 20 |) |` Save |
|00003d50| 74 68 65 20 72 65 63 6f | 72 64 0d 20 20 20 20 20 |the reco|rd. |
|00003d60| 20 20 20 20 20 20 20 20 | 20 20 20 45 6c 73 65 0d | | Else.|
|00003d70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003d80| 20 20 20 24 4c 69 6e 65 | 3a 3d 24 4e 62 4c 69 6e | $Line|:=$NbLin|
|00003d90| 65 73 2b 31 0d 20 20 20 | 20 20 20 20 20 20 20 20 |es+1. | |
|00003da0| 20 20 20 20 20 20 20 20 | 24 56 61 6c 69 64 54 72 | |$ValidTr|
|00003db0| 61 6e 73 3a 3d 46 61 6c | 73 65 0d 20 20 20 20 20 |ans:=Fal|se. |
|00003dc0| 20 20 20 20 20 20 20 20 | 20 20 20 45 6e 64 20 69 | | End i|
|00003dd0| 66 0d 0d 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |f.. | |
|00003de0| 20 20 4e 45 58 54 20 52 | 45 43 4f 52 44 28 5b 49 | NEXT R|ECORD([I|
|00003df0| 6e 76 6f 69 63 65 20 4c | 69 6e 65 73 5d 29 20 60 |nvoice L|ines]) `|
|00003e00| 47 6f 20 6e 65 78 74 20 | 6c 69 6e 65 0d 20 20 20 |Go next |line. |
|00003e10| 20 20 20 20 20 20 20 45 | 6e 64 20 66 6f 72 0d 0d | E|nd for..|
|00003e20| 52 45 41 44 20 4f 4e 4c | 59 28 5b 50 61 72 74 73 |READ ONL|Y([Parts|
|00003e30| 5d 29 0d 0d 49 66 20 28 | 24 56 61 6c 69 64 54 72 |])..If (|$ValidTr|
|00003e40| 61 6e 73 29 0d 20 20 20 | 20 53 41 56 45 20 52 45 |ans). | SAVE RE|
|00003e50| 43 4f 52 44 28 5b 49 6e | 76 6f 69 63 65 73 5d 29 |CORD([In|voices])|
|00003e60| 0d 20 20 20 20 56 41 4c | 49 44 41 54 45 20 54 52 |. VAL|IDATE TR|
|00003e70| 41 4e 53 41 43 54 49 4f | 4e 0d 45 6c 73 65 0d 20 |ANSACTIO|N.Else. |
|00003e80| 20 20 20 43 41 4e 43 45 | 4c 20 54 52 41 4e 53 41 | CANCE|L TRANSA|
|00003e90| 43 54 49 4f 4e 20 0d 45 | 6e 64 20 69 66 20 0d 0d |CTION .E|nd if ..|
|00003ea0| 43 41 4e 43 45 4c 20 0d | 0d 0d 0d 49 6e 20 74 68 |CANCEL .|...In th|
|00003eb0| 65 20 70 72 6f 63 65 64 | 75 72 65 20 61 62 6f 76 |e proced|ure abov|
|00003ec0| 65 20 72 65 67 61 72 64 | 6c 65 73 73 20 6f 66 20 |e regard|less of |
|00003ed0| 74 68 65 20 62 75 74 74 | 6f 6e 20 63 6c 69 63 6b |the butt|on click|
|00003ee0| 65 64 2c 20 77 65 20 65 | 78 65 63 75 74 65 20 74 |ed, we e|xecute t|
|00003ef0| 68 65 20 ca 43 41 4e 43 | 45 4c 2e 20 54 68 65 20 |he .CANC|EL. The |
|00003f00| 6e 65 77 20 72 65 63 6f | 72 64 20 69 73 20 6e 6f |new reco|rd is no|
|00003f10| 74 20 76 61 6c 69 64 61 | 74 65 64 20 62 79 20 61 |t valida|ted by a|
|00003f20| 20 63 61 6c 6c 20 74 6f | 20 ca 41 43 43 45 50 54 | call to| .ACCEPT|
|00003f30| 20 62 75 74 20 62 79 20 | 74 68 65 20 53 41 56 45 | but by |the SAVE|
|00003f40| ca 52 45 43 4f 52 44 20 | 63 6f 6d 6d 61 6e 64 2e |.RECORD |command.|
|00003f50| 20 41 73 20 79 6f 75 20 | 63 61 6e 20 73 65 65 20 | As you |can see |
|00003f60| 74 68 65 20 53 41 56 45 | ca 52 45 43 4f 52 44 20 |the SAVE|.RECORD |
|00003f70| 69 73 20 63 61 6c 6c 65 | 64 20 6a 75 73 74 20 62 |is calle|d just b|
|00003f80| 65 66 6f 72 65 20 74 68 | 65 20 56 41 4c 49 44 41 |efore th|e VALIDA|
|00003f90| 54 45 ca 54 52 41 4e 53 | 41 43 54 49 4f 4e 20 63 |TE.TRANS|ACTION c|
|00003fa0| 6f 6d 6d 61 6e 64 2e 20 | 54 68 65 72 65 66 6f 72 |ommand. |Therefor|
|00003fb0| 65 2c 20 73 61 76 69 6e | 67 20 74 68 65 20 5b 49 |e, savin|g the [I|
|00003fc0| 6e 76 6f 69 63 65 73 5d | 20 72 65 63 6f 72 64 20 |nvoices]| record |
|00003fd0| 69 73 20 61 63 74 75 61 | 6c 6c 79 20 61 20 70 61 |is actua|lly a pa|
|00003fe0| 72 74 20 6f 66 20 74 68 | 65 20 74 72 61 6e 73 61 |rt of th|e transa|
|00003ff0| 63 74 69 6f 6e 2e 20 43 | 61 6c 6c 69 6e 67 20 74 |ction. C|alling t|
|00004000| 68 65 20 ca 41 43 43 45 | 50 54 20 63 6f 6d 6d 61 |he .ACCE|PT comma|
|00004010| 6e 64 20 77 6f 75 6c 64 | 20 61 6c 73 6f 20 76 61 |nd would| also va|
|00004020| 6c 69 64 61 74 65 20 74 | 68 65 20 72 65 63 6f 72 |lidate t|he recor|
|00004030| 64 20 62 75 74 20 69 6e | 20 74 68 69 73 20 63 61 |d but in| this ca|
|00004040| 73 65 20 74 68 65 20 74 | 72 61 6e 73 61 63 74 69 |se the t|ransacti|
|00004050| 6f 6e 20 77 6f 75 6c 64 | 20 62 65 20 76 61 6c 69 |on would| be vali|
|00004060| 64 61 74 65 64 20 62 65 | 66 6f 72 65 20 74 68 65 |dated be|fore the|
|00004070| 20 49 6e 76 6f 69 63 65 | 20 77 61 73 20 73 61 76 | Invoice| was sav|
|00004080| 65 64 2e 20 49 6e 20 6f | 74 68 65 72 20 77 6f 72 |ed. In o|ther wor|
|00004090| 64 73 2c 20 74 68 65 20 | 72 65 63 6f 72 64 20 77 |ds, the |record w|
|000040a0| 6f 75 6c 64 20 62 65 20 | 73 61 76 65 64 20 6f 75 |ould be |saved ou|
|000040b0| 74 73 69 64 65 20 74 68 | 65 20 74 72 61 6e 73 61 |tside th|e transa|
|000040c0| 63 74 69 6f 6e 2e 0d 0d | 0d 00 00 06 9a 4d 61 74 |ction...|.....Mat|
|000040d0| 68 65 6d 61 74 69 63 61 | 6c ca 46 75 6e 63 74 69 |hematica|l.Functi|
|000040e0| 6f 6e 73 0d 0d 0d 54 68 | 65 73 65 20 66 75 6e 63 |ons...Th|ese func|
|000040f0| 74 69 6f 6e 73 20 69 6e | 20 74 68 69 73 20 73 65 |tions in| this se|
|00004100| 63 74 69 6f 6e 20 70 65 | 72 66 6f 72 6d 20 63 61 |ction pe|rform ca|
|00004110| 6c 63 75 6c 61 74 69 6f | 6e 73 20 6f 6e 20 61 20 |lculatio|ns on a |
|00004120| 73 65 72 69 65 73 20 6f | 66 20 76 61 6c 75 65 73 |series o|f values|
|00004130| 2e 20 54 68 65 20 ca 41 | 76 65 72 61 67 65 2c 20 |. The .A|verage, |
|00004140| ca 4d 61 78 2c 20 ca 4d | 69 6e 2c 20 ca 53 75 6d |.Max, .M|in, .Sum|
|00004150| 2c 20 53 75 6d ca 73 71 | 75 61 72 65 73 2c 20 53 |, Sum.sq|uares, S|
|00004160| 74 64 ca 64 65 76 69 61 | 74 69 6f 6e 2c 20 61 6e |td.devia|tion, an|
|00004170| 64 20 ca 56 61 72 69 61 | 6e 63 65 20 66 75 6e 63 |d .Varia|nce func|
|00004180| 74 69 6f 6e 73 20 63 61 | 6e 20 62 65 20 61 70 70 |tions ca|n be app|
|00004190| 6c 69 65 64 20 74 6f 20 | 66 69 65 6c 64 73 20 6f |lied to |fields o|
|000041a0| 72 20 73 75 62 66 69 65 | 6c 64 73 2e 20 49 6e 20 |r subfie|lds. In |
|000041b0| 74 68 65 20 63 61 73 65 | 20 6f 66 20 61 20 66 69 |the case| of a fi|
|000041c0| 65 6c 64 2c 20 74 68 65 | 79 20 61 72 65 20 61 70 |eld, the|y are ap|
|000041d0| 70 6c 69 65 64 20 74 6f | 20 61 20 73 65 6c 65 63 |plied to| a selec|
|000041e0| 74 69 6f 6e 20 6f 66 20 | 72 65 63 6f 72 64 73 2e |tion of |records.|
|000041f0| 20 49 6e 20 74 68 65 20 | 63 61 73 65 20 6f 66 20 | In the |case of |
|00004200| 61 20 73 75 62 66 69 65 | 6c 64 2c 20 74 68 65 79 |a subfie|ld, they|
|00004210| 20 61 72 65 20 61 70 70 | 6c 69 65 64 20 74 6f 20 | are app|lied to |
|00004220| 61 20 73 65 6c 65 63 74 | 69 6f 6e 20 6f 66 20 74 |a select|ion of t|
|00004230| 68 65 20 73 75 62 72 65 | 63 6f 72 64 73 20 6f 66 |he subre|cords of|
|00004240| 20 74 68 65 20 63 75 72 | 72 65 6e 74 20 72 65 63 | the cur|rent rec|
|00004250| 6f 72 64 2e 20 4e 6f 74 | 65 20 74 68 61 74 20 74 |ord. Not|e that t|
|00004260| 68 65 20 53 75 6d ca 73 | 71 75 61 72 65 73 2c 20 |he Sum.s|quares, |
|00004270| 53 74 64 ca 64 65 76 69 | 61 74 69 6f 6e 2c 20 61 |Std.devi|ation, a|
|00004280| 6e 64 20 ca 56 61 72 69 | 61 6e 63 65 20 66 75 6e |nd .Vari|ance fun|
|00004290| 63 74 69 6f 6e 73 20 63 | 61 6e 20 62 65 20 75 73 |ctions c|an be us|
|000042a0| 65 64 20 6f 6e 20 61 20 | 66 69 65 6c 64 20 6f 6e |ed on a |field on|
|000042b0| 6c 79 20 64 75 72 69 6e | 67 20 70 72 69 6e 74 69 |ly durin|g printi|
|000042c0| 6e 67 2e 0d 0d 20 20 20 | 20 20 20 ca 41 76 65 72 |ng... | .Aver|
|000042d0| 61 67 65 0d 20 20 20 20 | 20 20 ca 4d 61 78 0d 20 |age. | .Max. |
|000042e0| 20 20 20 20 20 ca 4d 69 | 6e 0d 20 20 20 20 20 20 | .Mi|n. |
|000042f0| ca 53 75 6d 09 0d 20 20 | 20 20 20 20 20 20 53 74 |.Sum.. | St|
|00004300| 64 ca 64 65 76 69 61 74 | 69 6f 6e 0d 20 20 20 20 |d.deviat|ion. |
|00004310| 20 20 20 20 53 75 6d ca | 73 71 75 61 72 65 73 09 | Sum.|squares.|
|00004320| 0d 20 20 20 20 20 20 ca | 56 61 72 69 61 6e 63 65 |. .|Variance|
|00004330| 0d 0d 0d 54 68 65 73 65 | 20 66 75 6e 63 74 69 6f |...These| functio|
|00004340| 6e 73 20 77 6f 72 6b 20 | 6f 6e 20 6e 75 6d 65 72 |ns work |on numer|
|00004350| 69 63 20 64 61 74 61 20 | 6f 6e 6c 79 2e 20 45 61 |ic data |only. Ea|
|00004360| 63 68 20 6f 66 20 74 68 | 65 73 65 20 66 75 6e 63 |ch of th|ese func|
|00004370| 74 69 6f 6e 73 20 72 65 | 74 75 72 6e 73 20 61 20 |tions re|turns a |
|00004380| 6e 75 6d 65 72 69 63 20 | 76 61 6c 75 65 2e 0d 0d |numeric |value...|
|00004390| 0d 55 73 69 6e 67 20 61 | 20 46 69 65 6c 64 0d 0d |.Using a| Field..|
|000043a0| 57 68 65 6e 20 ca 41 76 | 65 72 61 67 65 2c 20 ca |When .Av|erage, .|
|000043b0| 4d 61 78 2c 20 ca 4d 69 | 6e 2c 20 6f 72 20 ca 53 |Max, .Mi|n, or .S|
|000043c0| 75 6d 20 61 72 65 20 75 | 73 65 64 20 6f 6e 20 61 |um are u|sed on a|
|000043d0| 20 66 69 65 6c 64 2c 20 | 74 68 65 79 20 6d 75 73 | field, |they mus|
|000043e0| 74 20 6c 6f 61 64 20 65 | 61 63 68 20 72 65 63 6f |t load e|ach reco|
|000043f0| 72 64 20 69 6e 20 74 68 | 65 20 63 75 72 72 65 6e |rd in th|e curren|
|00004400| 74 20 73 65 6c 65 63 74 | 69 6f 6e 20 74 6f 20 63 |t select|ion to c|
|00004410| 61 6c 63 75 6c 61 74 65 | 20 74 68 65 20 72 65 73 |alculate| the res|
|00004420| 75 6c 74 2e 20 49 66 20 | 74 68 65 72 65 20 61 72 |ult. If |there ar|
|00004430| 65 20 6d 61 6e 79 20 72 | 65 63 6f 72 64 73 2c 20 |e many r|ecords, |
|00004440| 74 68 69 73 20 70 72 6f | 63 65 73 73 20 6d 61 79 |this pro|cess may|
|00004450| 20 74 61 6b 65 20 73 6f | 6d 65 20 74 69 6d 65 2e | take so|me time.|
|00004460| 0d 0d 57 68 65 6e 20 74 | 68 65 73 65 20 66 75 6e |..When t|hese fun|
|00004470| 63 74 69 6f 6e 73 20 61 | 72 65 20 75 73 65 64 20 |ctions a|re used |
|00004480| 69 6e 20 61 20 72 65 70 | 6f 72 74 2c 20 74 68 65 |in a rep|ort, the|
|00004490| 79 20 62 65 68 61 76 65 | 20 64 69 66 66 65 72 65 |y behave| differe|
|000044a0| 6e 74 6c 79 20 74 68 61 | 6e 20 61 74 20 6f 74 68 |ntly tha|n at oth|
|000044b0| 65 72 20 74 69 6d 65 73 | 2e 20 54 68 69 73 20 69 |er times|. This i|
|000044c0| 73 20 62 65 63 61 75 73 | 65 20 74 68 65 20 72 65 |s becaus|e the re|
|000044d0| 70 6f 72 74 20 69 74 73 | 65 6c 66 20 6d 75 73 74 |port its|elf must|
|000044e0| 20 6c 6f 61 64 20 65 61 | 63 68 20 72 65 63 6f 72 | load ea|ch recor|
|000044f0| 64 2e 20 55 73 65 20 74 | 68 65 73 65 20 66 75 6e |d. Use t|hese fun|
|00004500| 63 74 69 6f 6e 73 20 69 | 6e 20 61 20 6c 61 79 6f |ctions i|n a layo|
|00004510| 75 74 20 70 72 6f 63 65 | 64 75 72 65 20 6f 72 20 |ut proce|dure or |
|00004520| 73 63 72 69 70 74 20 77 | 68 65 6e 20 79 6f 75 20 |script w|hen you |
|00004530| 61 72 65 20 70 72 69 6e | 74 69 6e 67 20 77 69 74 |are prin|ting wit|
|00004540| 68 20 74 68 65 20 50 52 | 49 4e 54 ca 53 45 4c 45 |h the PR|INT.SELE|
|00004550| 43 54 49 4f 4e 20 63 6f | 6d 6d 61 6e 64 20 6f 72 |CTION co|mmand or|
|00004560| 20 77 68 65 6e 20 79 6f | 75 20 61 72 65 20 70 72 | when yo|u are pr|
|00004570| 69 6e 74 69 6e 67 20 69 | 6e 20 74 68 65 20 55 73 |inting i|n the Us|
|00004580| 65 72 20 65 6e 76 69 72 | 6f 6e 6d 65 6e 74 20 62 |er envir|onment b|
|00004590| 79 20 63 68 6f 6f 73 69 | 6e 67 20 50 72 69 6e 74 |y choosi|ng Print|
|000045a0| 20 66 72 6f 6d 20 74 68 | 65 20 46 69 6c 65 20 6d | from th|e File m|
|000045b0| 65 6e 75 2e 0d 0d 57 68 | 65 6e 20 79 6f 75 20 75 |enu...Wh|en you u|
|000045c0| 73 65 20 74 68 65 73 65 | 20 66 75 6e 63 74 69 6f |se these| functio|
|000045d0| 6e 73 20 69 6e 20 61 20 | 72 65 70 6f 72 74 2c 20 |ns in a |report, |
|000045e0| 74 68 65 20 76 61 6c 75 | 65 73 20 74 68 61 74 20 |the valu|es that |
|000045f0| 61 72 65 20 72 65 74 75 | 72 6e 65 64 20 61 72 65 |are retu|rned are|
|00004600| 20 72 65 6c 69 61 62 6c | 65 20 6f 6e 6c 79 20 61 | reliabl|e only a|
|00004610| 74 20 62 72 65 61 6b 20 | 6c 65 76 65 6c 20 30 2e |t break |level 0.|
|00004620| 20 42 72 65 61 6b 20 70 | 72 6f 63 65 73 73 69 6e | Break p|rocessin|
|00004630| 67 20 73 68 6f 75 6c 64 | 20 62 65 20 74 75 72 6e |g should| be turn|
|00004640| 65 64 20 6f 6e 2e 20 54 | 68 69 73 20 6d 65 61 6e |ed on. T|his mean|
|00004650| 73 20 74 68 61 74 20 74 | 68 65 79 20 61 72 65 20 |s that t|hey are |
|00004660| 75 73 65 66 75 6c 20 6f | 6e 6c 79 20 61 74 20 74 |useful o|nly at t|
|00004670| 68 65 20 65 6e 64 20 6f | 66 20 61 20 72 65 70 6f |he end o|f a repo|
|00004680| 72 74 20 61 66 74 65 72 | 20 61 6c 6c 20 74 68 65 |rt after| all the|
|00004690| 20 72 65 63 6f 72 64 73 | 20 68 61 76 65 20 62 65 | records| have be|
|000046a0| 65 6e 20 70 72 6f 63 65 | 73 73 65 64 2e 20 59 6f |en proce|ssed. Yo|
|000046b0| 75 20 6f 6e 6c 79 20 75 | 73 65 20 74 68 65 20 66 |u only u|se the f|
|000046c0| 75 6e 63 74 69 6f 6e 73 | 20 69 6e 20 61 20 73 63 |unctions| in a sc|
|000046d0| 72 69 70 74 20 66 6f 72 | 20 61 20 6e 6f 6e 2d 65 |ript for| a non-e|
|000046e0| 6e 74 65 72 61 62 6c 65 | 20 61 72 65 61 20 74 68 |nterable| area th|
|000046f0| 61 74 20 69 73 20 69 6e | 63 6c 75 64 65 64 20 69 |at is in|cluded i|
|00004700| 6e 20 74 68 65 20 42 30 | 20 42 72 65 61 6b 20 61 |n the B0| Break a|
|00004710| 72 65 61 2e 20 54 68 65 | 20 73 63 72 69 70 74 20 |rea. The| script |
|00004720| 61 73 73 69 67 6e 73 20 | 74 68 65 20 76 61 6c 75 |assigns |the valu|
|00004730| 65 20 72 65 74 75 72 6e | 65 64 20 74 6f 20 74 68 |e return|ed to th|
|00004740| 65 20 76 61 72 69 61 62 | 6c 65 20 61 73 73 6f 63 |e variab|le assoc|
|00004750| 69 61 74 65 64 20 77 69 | 74 68 20 74 68 65 20 61 |iated wi|th the a|
|00004760| 72 65 61 2e 0d 0d 0d 00 | 00 0d ca ca 50 52 49 4e |rea.....|....PRIN|
|00004770| 54 49 4e 47 0d 20 0d 0d | 50 72 69 6e 74 69 6e 67 |TING. ..|Printing|
|00004780| 20 72 65 70 6f 72 74 73 | 20 69 73 20 6f 66 74 65 | reports| is ofte|
|00004790| 6e 20 74 68 65 20 6d 6f | 73 74 20 69 6d 70 6f 72 |n the mo|st impor|
|000047a0| 74 61 6e 74 20 6a 6f 62 | 20 6f 66 20 61 20 64 61 |tant job| of a da|
|000047b0| 74 61 62 61 73 65 2e 20 | 54 68 65 20 63 6f 6d 6d |tabase. |The comm|
|000047c0| 61 6e 64 73 20 69 6e 20 | 74 68 69 73 20 73 65 63 |ands in |this sec|
|000047d0| 74 69 6f 6e 20 61 6c 6c | 6f 77 20 79 6f 75 20 74 |tion all|ow you t|
|000047e0| 6f 20 75 73 65 20 34 74 | 68 20 44 49 4d 45 4e 53 |o use 4t|h DIMENS|
|000047f0| 6c 4f 4e 27 73 20 66 6c | 65 78 69 62 6c 65 20 72 |lON's fl|exible r|
|00004800| 65 70 6f 72 74 69 6e 67 | 20 63 61 70 61 62 69 6c |eporting| capabil|
|00004810| 69 74 69 65 73 2e 0d 0d | 20 20 20 20 42 52 45 41 |ities...| BREA|
|00004820| 4b ca 4c 45 56 45 4c 0d | 20 20 20 20 46 4f 52 4d |K.LEVEL.| FORM|
|00004830| ca 46 45 45 44 0d 20 20 | ca 4c 65 76 65 6c 0d 20 |.FEED. |.Level. |
|00004840| 20 ca 41 43 43 55 4d 55 | 4c 41 54 45 0d 20 20 09 | .ACCUMU|LATE. .|
|00004850| 50 41 47 45 ca 53 45 54 | 55 50 0d 20 20 09 50 52 |PAGE.SET|UP. .PR|
|00004860| 49 4e 54 ca 4c 41 42 45 | 4c 0d 20 20 09 50 52 49 |INT.LABE|L. .PRI|
|00004870| 4e 54 ca 4c 41 59 4f 55 | 54 0d 09 ca 52 45 50 4f |NT.LAYOU|T...REPO|
|00004880| 52 54 0d 20 20 09 50 52 | 49 4e 54 ca 53 45 4c 45 |RT. .PR|INT.SELE|
|00004890| 43 54 49 4f 4e 0d 09 ca | 53 75 62 74 6f 74 61 6c |CTION...|Subtotal|
|000048a0| 0d 20 20 20 50 52 49 4e | 54 ca 53 45 54 54 49 4e |. PRIN|T.SETTIN|
|000048b0| 47 53 20 0d 20 20 20 50 | 72 69 6e 74 69 6e 67 ca |GS . P|rinting.|
|000048c0| 70 61 67 65 0d 0d 0d 59 | 6f 75 20 63 61 6e 20 75 |page...Y|ou can u|
|000048d0| 73 65 20 74 68 65 20 50 | 52 49 4e 54 ca 53 45 4c |se the P|RINT.SEL|
|000048e0| 45 43 54 49 4f 4e 2c 20 | 50 52 49 4e 54 ca 4c 41 |ECTION, |PRINT.LA|
|000048f0| 59 4f 55 54 2c 20 61 6e | 64 20 50 52 49 4e 54 ca |YOUT, an|d PRINT.|
|00004900| 4c 41 42 45 4c 20 63 6f | 6d 6d 61 6e 64 73 20 74 |LABEL co|mmands t|
|00004910| 6f 20 67 65 6e 65 72 61 | 74 65 20 72 65 70 6f 72 |o genera|te repor|
|00004920| 74 73 20 77 69 74 68 20 | 6c 61 79 6f 75 74 73 20 |ts with |layouts |
|00004930| 63 72 65 61 74 65 64 20 | 69 6e 20 74 68 65 20 44 |created |in the D|
|00004940| 65 73 69 67 6e 20 65 6e | 76 69 72 6f 6e 6d 65 6e |esign en|vironmen|
|00004950| 74 2e 20 59 6f 75 20 63 | 61 6e 20 75 73 65 20 74 |t. You c|an use t|
|00004960| 68 65 20 ca 52 45 50 4f | 52 54 20 61 6e 64 20 50 |he .REPO|RT and P|
|00004970| 52 49 4e 54 ca 4c 41 42 | 45 4c 20 63 6f 6d 6d 61 |RINT.LAB|EL comma|
|00004980| 6e 64 73 20 74 6f 20 67 | 65 6e 65 72 61 74 65 20 |nds to g|enerate |
|00004990| 72 65 70 6f 72 74 73 20 | 77 69 74 68 6f 75 74 20 |reports |without |
|000049a0| 75 73 69 6e 67 20 6c 61 | 79 6f 75 74 73 2e 0d 0d |using la|youts...|
|000049b0| 41 20 72 65 70 6f 72 74 | 20 70 72 69 6e 74 65 64 |A report| printed|
|000049c0| 20 77 69 74 68 20 61 20 | 6c 61 79 6f 75 74 20 63 | with a |layout c|
|000049d0| 61 6e 20 68 61 76 65 20 | 61 6c 6d 6f 73 74 20 61 |an have |almost a|
|000049e0| 6e 79 20 6b 69 6e 64 20 | 6f 66 20 64 65 73 69 67 |ny kind |of desig|
|000049f0| 6e 2e 20 54 68 65 20 72 | 65 70 6f 72 74 20 63 61 |n. The r|eport ca|
|00004a00| 6e 20 69 6e 63 6c 75 64 | 65 20 67 72 61 70 68 69 |n includ|e graphi|
|00004a10| 63 73 2c 20 61 6e 64 20 | 74 68 65 20 65 6c 65 6d |cs, and |the elem|
|00004a20| 65 6e 74 73 20 6d 61 6b | 69 6e 67 20 75 70 20 74 |ents mak|ing up t|
|00004a30| 68 65 20 72 65 70 6f 72 | 74 20 63 61 6e 20 62 65 |he repor|t can be|
|00004a40| 20 61 72 72 61 6e 67 65 | 64 20 69 6e 20 61 6e 79 | arrange|d in any|
|00004a50| 20 6d 61 6e 6e 65 72 2e | 20 41 20 72 65 70 6f 72 | manner.| A repor|
|00004a60| 74 20 70 72 69 6e 74 65 | 64 20 77 69 74 68 20 61 |t printe|d with a|
|00004a70| 20 6c 61 79 6f 75 74 20 | 61 6c 73 6f 20 65 78 65 | layout |also exe|
|00004a80| 63 75 74 65 73 20 74 68 | 65 20 61 73 73 6f 63 69 |cutes th|e associ|
|00004a90| 61 74 65 64 20 6c 61 79 | 6f 75 74 20 70 72 6f 63 |ated lay|out proc|
|00004aa0| 65 64 75 72 65 2c 20 77 | 68 69 63 68 20 67 69 76 |edure, w|hich giv|
|00004ab0| 65 73 20 74 72 65 6d 65 | 6e 64 6f 75 73 20 70 72 |es treme|ndous pr|
|00004ac0| 6f 63 65 73 73 69 6e 67 | 20 63 61 70 61 62 69 6c |ocessing| capabil|
|00004ad0| 69 74 69 65 73 2e 0d 0d | 52 65 70 6f 72 74 73 20 |ities...|Reports |
|00004ae0| 67 65 6e 65 72 61 74 65 | 64 20 77 69 74 68 20 74 |generate|d with t|
|00004af0| 68 65 20 51 75 69 63 6b | 20 52 65 70 6f 72 74 20 |he Quick| Report |
|00004b00| 61 6e 64 20 4c 61 62 65 | 6c 20 65 64 69 74 6f 72 |and Labe|l editor|
|00004b10| 73 20 61 72 65 20 75 73 | 75 61 6c 6c 79 20 73 69 |s are us|ually si|
|00004b20| 6d 70 6c 65 72 20 69 6e | 20 64 65 73 69 67 6e 2e |mpler in| design.|
|00004b30| 20 54 68 65 20 75 73 65 | 72 20 63 61 6e 20 64 65 | The use|r can de|
|00004b40| 73 69 67 6e 20 61 20 72 | 65 70 6f 72 74 20 2a 66 |sign a r|eport *f|
|00004b50| 72 6f 6d 20 73 63 72 61 | 74 63 68 20 62 79 20 75 |rom scra|tch by u|
|00004b60| 73 69 6e 67 20 74 68 65 | 73 65 20 65 64 69 74 6f |sing the|se edito|
|00004b70| 72 73 2e 20 54 68 65 20 | 72 65 70 6f 72 74 20 64 |rs. The |report d|
|00004b80| 65 73 69 67 6e 73 20 63 | 61 6e 20 62 65 20 73 74 |esigns c|an be st|
|00004b90| 6f 72 65 64 20 6f 6e 20 | 64 69 73 6b 2e 20 54 68 |ored on |disk. Th|
|00004ba0| 65 73 65 20 72 65 70 6f | 72 74 73 20 64 6f 20 6e |ese repo|rts do n|
|00004bb0| 6f 74 20 75 73 65 20 6c | 61 79 6f 75 74 73 20 61 |ot use l|ayouts a|
|00004bc0| 6e 64 20 74 68 65 72 65 | 66 6f 72 65 20 64 6f 20 |nd there|fore do |
|00004bd0| 6e 6f 74 20 65 78 65 63 | 75 74 65 20 6c 61 79 6f |not exec|ute layo|
|00004be0| 75 74 20 70 72 6f 63 65 | 64 75 72 65 73 2e 0d 0d |ut proce|dures...|
|00004bf0| 54 68 65 20 74 68 72 65 | 65 20 70 72 69 6d 61 72 |The thre|e primar|
|00004c00| 79 20 72 65 70 6f 72 74 | 69 6e 67 20 63 6f 6d 6d |y report|ing comm|
|00004c10| 61 6e 64 73 2c 20 ca 52 | 45 50 4f 52 54 2c 20 50 |ands, .R|EPORT, P|
|00004c20| 52 49 4e 54 ca 53 45 4c | 45 43 54 49 4f 4e 2c 20 |RINT.SEL|ECTION, |
|00004c30| 61 6e 64 20 50 52 49 4e | 54 ca 4c 41 59 4f 55 54 |and PRIN|T.LAYOUT|
|00004c40| 2c 20 76 61 72 79 20 69 | 6e 20 64 65 67 72 65 65 |, vary i|n degree|
|00004c50| 20 6f 66 20 66 6c 65 78 | 69 62 69 6c 69 74 79 2e | of flex|ibility.|
|00004c60| 20 47 65 6e 65 72 61 6c | 6c 79 2c 20 74 68 65 20 | General|ly, the |
|00004c70| 6d 6f 72 65 20 66 6c 65 | 78 69 62 6c 65 20 61 20 |more fle|xible a |
|00004c80| 63 6f 6d 6d 61 6e 64 20 | 69 73 2c 20 74 68 65 20 |command |is, the |
|00004c90| 6d 6f 72 65 20 79 6f 75 | 20 61 73 20 61 20 64 65 |more you| as a de|
|00004ca0| 73 69 67 6e 65 72 20 6e | 65 65 64 20 74 6f 20 64 |signer n|eed to d|
|00004cb0| 6f 20 74 6f 20 67 65 6e | 65 72 61 74 65 20 61 20 |o to gen|erate a |
|00004cc0| 72 65 70 6f 72 74 2e 0d | 0d 0d ca 52 45 50 4f 52 |report..|...REPOR|
|00004cd0| 54 20 69 73 20 74 68 65 | 20 73 69 6d 70 6c 65 73 |T is the| simples|
|00004ce0| 74 20 72 65 70 6f 72 74 | 20 67 65 6e 65 72 61 74 |t report| generat|
|00004cf0| 6f 72 2e 20 49 74 20 75 | 73 65 73 20 74 68 65 20 |or. It u|ses the |
|00004d00| 73 61 6d 65 20 51 75 69 | 63 6b 20 52 65 70 6f 72 |same Qui|ck Repor|
|00004d10| 74 20 65 64 69 74 6f 72 | 20 74 68 61 74 20 79 6f |t editor| that yo|
|00004d20| 75 20 75 73 65 20 69 6e | 20 74 68 65 20 55 73 65 |u use in| the Use|
|00004d30| 72 20 65 6e 76 69 72 6f | 6e 6d 65 6e 74 2e 20 54 |r enviro|nment. T|
|00004d40| 68 65 20 75 73 65 72 20 | 69 6e 74 65 72 66 61 63 |he user |interfac|
|00004d50| 65 20 69 73 20 61 20 73 | 69 6d 70 6c 65 20 70 6f |e is a s|imple po|
|00004d60| 69 6e 74 2c 20 63 6c 69 | 63 6b 2c 20 61 6e 64 20 |int, cli|ck, and |
|00004d70| 64 72 61 67 20 69 6e 74 | 65 72 66 61 63 65 2e 20 |drag int|erface. |
|00004d80| 54 68 65 20 73 74 79 6c | 65 20 6f 66 20 61 20 72 |The styl|e of a r|
|00004d90| 65 70 6f 72 74 20 69 73 | 20 61 20 72 6f 77 20 61 |eport is| a row a|
|00004da0| 6e 64 20 63 6f 6c 75 6d | 6e 20 66 6f 72 6d 61 74 |nd colum|n format|
|00004db0| 20 74 68 61 74 20 63 61 | 6e 20 69 6e 63 6c 75 64 | that ca|n includ|
|00004dc0| 65 20 68 65 61 64 65 72 | 73 2c 20 66 6f 6f 74 65 |e header|s, foote|
|00004dd0| 72 73 2c 20 64 69 66 66 | 65 72 65 6e 74 20 66 6f |rs, diff|erent fo|
|00004de0| 6e 74 73 20 61 6e 64 20 | 73 74 79 6c 65 73 2c 20 |nts and |styles, |
|00004df0| 66 6f 72 6d 61 74 74 69 | 6e 67 2c 20 66 6f 72 6d |formatti|ng, form|
|00004e00| 75 6c 61 73 2c 20 62 72 | 65 61 6b 73 2c 20 74 6f |ulas, br|eaks, to|
|00004e10| 74 61 6c 73 2c 20 63 61 | 6c 63 75 6c 61 74 69 6f |tals, ca|lculatio|
|00004e20| 6e 73 2c 20 61 6e 64 20 | 6d 75 6c 74 69 63 6f 6c |ns, and |multicol|
|00004e30| 75 6d 6e 20 76 61 72 69 | 61 62 6c 65 2d 6c 65 6e |umn vari|able-len|
|00004e40| 67 74 68 20 74 65 78 74 | 2e 20 54 68 65 20 72 65 |gth text|. The re|
|00004e50| 70 6f 72 74 20 63 61 6e | 20 62 65 20 70 72 69 6e |port can| be prin|
|00004e60| 74 65 64 20 74 6f 20 61 | 20 68 69 67 68 2d 73 70 |ted to a| high-sp|
|00004e70| 65 65 64 20 73 65 72 69 | 61 6c 20 64 65 76 69 63 |eed seri|al devic|
|00004e80| 65 2e 20 54 68 65 20 72 | 65 70 6f 72 74 20 63 61 |e. The r|eport ca|
|00004e90| 6e 20 61 6c 73 6f 20 62 | 65 20 63 6f 6e 76 65 72 |n also b|e conver|
|00004ea0| 74 65 64 20 74 6f 20 61 | 20 67 72 61 70 68 20 6f |ted to a| graph o|
|00004eb0| 72 20 61 6e 20 41 53 43 | 49 49 20 66 69 6c 65 2e |r an ASC|II file.|
|00004ec0| 0d 0d 0d 50 52 49 4e 54 | ca 53 45 4c 45 43 54 49 |...PRINT|.SELECTI|
|00004ed0| 4f 4e 20 69 73 20 74 68 | 65 20 6d 6f 73 74 20 63 |ON is th|e most c|
|00004ee0| 6f 6d 6d 6f 6e 6c 79 20 | 75 73 65 64 20 70 72 69 |ommonly |used pri|
|00004ef0| 6e 74 69 6e 67 20 63 6f | 6d 6d 61 6e 64 2e 20 49 |nting co|mmand. I|
|00004f00| 74 20 75 73 65 73 20 61 | 6e 20 6f 75 74 70 75 74 |t uses a|n output|
|00004f10| 20 6c 61 79 6f 75 74 20 | 74 68 61 74 20 63 61 6e | layout |that can|
|00004f20| 20 62 65 20 6f 66 20 61 | 6e 79 20 64 65 73 69 67 | be of a|ny desig|
|00004f30| 6e 2e 20 54 68 65 20 63 | 6f 6d 6d 61 6e 64 20 61 |n. The c|ommand a|
|00004f40| 6c 6c 6f 77 73 20 68 65 | 61 64 65 72 73 2c 20 66 |llows he|aders, f|
|00004f50| 6f 6f 74 65 72 73 2c 20 | 64 69 66 66 65 72 65 6e |ooters, |differen|
|00004f60| 74 20 66 6f 6e 74 73 20 | 61 6e 64 20 73 74 79 6c |t fonts |and styl|
|00004f70| 65 73 2c 20 66 6f 72 6d | 61 74 74 69 6e 67 2c 20 |es, form|atting, |
|00004f80| 66 6f 72 6d 75 6c 61 73 | 2c 20 62 72 65 61 6b 73 |formulas|, breaks|
|00004f90| 2c 20 74 6f 74 61 6c 73 | 2c 20 61 6e 64 20 63 61 |, totals|, and ca|
|00004fa0| 6c 63 75 6c 61 74 69 6f | 6e 73 2e 20 53 69 6d 70 |lculatio|ns. Simp|
|00004fb0| 6c 65 20 72 65 70 6f 72 | 74 73 20 63 61 6e 20 62 |le repor|ts can b|
|00004fc0| 65 20 67 65 6e 65 72 61 | 74 65 64 20 77 69 74 68 |e genera|ted with|
|00004fd0| 6f 75 74 20 6c 61 79 6f | 75 74 20 70 72 6f 63 65 |out layo|ut proce|
|00004fe0| 64 75 72 65 73 2c 20 62 | 75 74 20 6d 6f 73 74 20 |dures, b|ut most |
|00004ff0| 72 65 70 6f 72 74 73 20 | 77 69 6c 6c 20 69 6e 63 |reports |will inc|
|00005000| 6c 75 64 65 20 61 20 6c | 61 79 6f 75 74 20 70 72 |lude a l|ayout pr|
|00005010| 6f 63 65 64 75 72 65 20 | 61 6e 64 20 73 63 72 69 |ocedure |and scri|
|00005020| 70 74 73 20 74 6f 20 70 | 72 6f 63 65 73 73 20 74 |pts to p|rocess t|
|00005030| 68 65 20 72 65 70 6f 72 | 74 2e 0d 0d 0d 50 52 49 |he repor|t....PRI|
|00005040| 4e 54 ca 4c 41 59 4f 55 | 54 20 69 73 20 74 68 65 |NT.LAYOU|T is the|
|00005050| 20 6d 6f 73 74 20 66 6c | 65 78 69 62 6c 65 20 6f | most fl|exible o|
|00005060| 66 20 61 6c 6c 20 74 68 | 65 20 70 72 69 6e 74 69 |f all th|e printi|
|00005070| 6e 67 20 63 6f 6d 6d 61 | 6e 64 73 20 61 6e 64 20 |ng comma|nds and |
|00005080| 61 6c 73 6f 20 74 68 65 | 20 6d 6f 73 74 20 64 65 |also the| most de|
|00005090| 6d 61 6e 64 69 6e 67 20 | 66 6f 72 20 74 68 65 20 |manding |for the |
|000050a0| 64 65 73 69 67 6e 65 72 | 2e 20 49 74 20 61 6c 6c |designer|. It all|
|000050b0| 6f 77 73 20 79 6f 75 20 | 74 6f 20 6d 69 78 20 64 |ows you |to mix d|
|000050c0| 69 66 66 65 72 65 6e 74 | 20 6c 61 79 6f 75 74 73 |ifferent| layouts|
|000050d0| 20 6f 6e 20 74 68 65 20 | 73 61 6d 65 20 70 61 67 | on the |same pag|
|000050e0| 65 20 61 6e 64 20 74 6f | 20 69 6e 63 6c 75 64 65 |e and to| include|
|000050f0| 20 66 6f 72 6d 20 66 65 | 65 64 73 20 61 74 20 61 | form fe|eds at a|
|00005100| 6e 79 20 74 69 6d 65 20 | 64 75 72 69 6e 67 20 74 |ny time |during t|
|00005110| 68 65 20 72 65 70 6f 72 | 74 2e 20 50 52 49 4e 54 |he repor|t. PRINT|
|00005120| ca 4c 41 59 4f 55 54 20 | 69 73 20 75 73 65 64 20 |.LAYOUT |is used |
|00005130| 66 6f 72 20 74 68 65 20 | 6d 6f 73 74 20 63 6f 6d |for the |most com|
|00005140| 70 6c 65 78 20 70 72 69 | 6e 74 69 6e 67 20 6a 6f |plex pri|nting jo|
|00005150| 62 73 2e 0d 0d 0d 50 52 | 49 4e 54 ca 4c 41 42 45 |bs....PR|INT.LABE|
|00005160| 4c 20 63 61 6e 20 70 72 | 69 6e 74 20 6c 61 62 65 |L can pr|int labe|
|00005170| 6c 73 20 77 69 74 68 20 | 61 20 6c 61 79 6f 75 74 |ls with |a layout|
|00005180| 2c 20 70 72 6f 76 69 64 | 69 6e 67 20 61 20 68 69 |, provid|ing a hi|
|00005190| 67 68 20 64 65 67 72 65 | 65 20 6f 66 20 66 6c 65 |gh degre|e of fle|
|000051a0| 78 69 62 69 6c 69 74 79 | 2c 20 6f 72 20 69 74 20 |xibility|, or it |
|000051b0| 63 61 6e 20 75 73 65 20 | 74 68 65 20 4c 61 62 65 |can use |the Labe|
|000051c0| 6c 20 65 64 69 74 6f 72 | 20 61 73 20 70 72 6f 76 |l editor| as prov|
|000051d0| 69 64 65 64 20 69 6e 20 | 74 68 65 20 55 73 65 72 |ided in |the User|
|000051e0| 20 65 6e 76 69 72 6f 6e | 6d 65 6e 74 2c 20 6c 65 | environ|ment, le|
|000051f0| 74 74 69 6e 67 20 74 68 | 65 20 75 73 65 72 20 64 |tting th|e user d|
|00005200| 65 73 69 67 6e 20 74 68 | 65 20 6c 61 62 65 6c 20 |esign th|e label |
|00005210| 61 73 20 6e 65 65 64 65 | 64 2e 20 53 69 6e 63 65 |as neede|d. Since|
|00005220| 20 69 74 20 63 61 6e 20 | 70 72 69 6e 74 20 72 65 | it can |print re|
|00005230| 63 6f 72 64 73 20 73 69 | 64 65 2d 62 79 2d 73 69 |cords si|de-by-si|
|00005240| 64 65 2c 20 74 68 69 73 | 20 63 6f 6d 6d 61 6e 64 |de, this| command|
|00005250| 20 63 61 6e 20 61 6c 73 | 6f 20 62 65 20 75 73 65 | can als|o be use|
|00005260| 64 20 74 6f 20 67 65 6e | 65 72 61 74 65 20 75 6e |d to gen|erate un|
|00005270| 75 73 75 61 6c 20 72 65 | 70 6f 72 74 73 2e 0d 0d |usual re|ports...|
|00005280| 0d 41 6c 6c 20 6f 66 20 | 74 68 65 20 70 72 69 6e |.All of |the prin|
|00005290| 74 20 63 6f 6d 6d 61 6e | 64 73 20 65 78 63 65 70 |t comman|ds excep|
|000052a0| 74 20 66 6f 72 20 50 52 | 49 4e 54 ca 4c 41 59 4f |t for PR|INT.LAYO|
|000052b0| 55 54 2c 20 70 72 69 6e | 74 20 74 68 65 20 63 75 |UT, prin|t the cu|
|000052c0| 72 72 65 6e 74 20 73 65 | 6c 65 63 74 69 6f 6e 2e |rrent se|lection.|
|000052d0| 20 49 74 20 69 73 20 63 | 6f 6d 6d 6f 6e 20 74 6f | It is c|ommon to|
|000052e0| 20 73 6f 72 74 20 74 68 | 65 20 73 65 6c 65 63 74 | sort th|e select|
|000052f0| 69 6f 6e 20 62 65 66 6f | 72 65 20 70 72 69 6e 74 |ion befo|re print|
|00005300| 69 6e 67 2e 0d 0d 57 68 | 65 6e 20 61 20 75 73 65 |ing...Wh|en a use|
|00005310| 72 20 70 72 69 6e 74 73 | 20 61 20 72 65 70 6f 72 |r prints| a repor|
|00005320| 74 2c 20 68 65 20 6f 72 | 20 73 68 65 20 6d 61 79 |t, he or| she may|
|00005330| 20 65 6c 65 63 74 20 74 | 6f 20 70 72 65 76 69 65 | elect t|o previe|
|00005340| 77 20 69 74 20 6f 6e 20 | 74 68 65 20 73 63 72 65 |w it on |the scre|
|00005350| 65 6e 2e 20 44 75 72 69 | 6e 67 20 70 72 69 6e 74 |en. Duri|ng print|
|00005360| 69 6e 67 2c 20 34 74 68 | 20 44 49 4d 45 4e 53 49 |ing, 4th| DIMENSI|
|00005370| 4f 4e 20 64 69 73 70 6c | 61 79 73 20 74 68 65 20 |ON displ|ays the |
|00005380| 63 75 72 72 65 6e 74 20 | 70 61 67 65 20 62 65 69 |current |page bei|
|00005390| 6e 67 20 70 72 69 6e 74 | 65 64 20 61 6e 64 20 74 |ng print|ed and t|
|000053a0| 68 65 20 73 74 61 74 75 | 73 20 6f 66 20 74 68 65 |he statu|s of the|
|000053b0| 20 70 72 69 6e 74 20 6a | 6f 62 2e 20 49 66 20 74 | print j|ob. If t|
|000053c0| 68 65 20 75 73 65 72 20 | 70 72 65 76 69 65 77 73 |he user |previews|
|000053d0| 20 69 74 20 6f 6e 20 74 | 68 65 20 73 63 72 65 65 | it on t|he scree|
|000053e0| 6e 2c 20 68 65 20 6f 72 | 20 73 68 65 20 6d 61 79 |n, he or| she may|
|000053f0| 20 70 72 69 6e 74 20 74 | 68 65 20 63 75 72 72 65 | print t|he curre|
|00005400| 6e 74 20 70 61 67 65 20 | 62 79 20 63 6c 69 63 6b |nt page |by click|
|00005410| 69 6e 67 20 74 68 65 20 | 50 72 69 6e 74 20 62 75 |ing the |Print bu|
|00005420| 74 74 6f 6e 2e 0d 0d 54 | 68 65 20 75 73 65 72 20 |tton...T|he user |
|00005430| 6d 61 79 20 63 61 6e 63 | 65 6c 20 70 72 69 6e 74 |may canc|el print|
|00005440| 69 6e 67 20 62 79 20 63 | 6c 69 63 6b 69 6e 67 20 |ing by c|licking |
|00005450| 74 68 65 20 53 74 6f 70 | 20 50 72 69 6e 74 69 6e |the Stop| Printin|
|00005460| 67 20 62 75 74 74 6f 6e | 2e 20 49 66 20 74 68 65 |g button|. If the|
|00005470| 20 75 73 65 72 20 63 61 | 6e 63 65 6c 73 20 70 72 | user ca|ncels pr|
|00005480| 69 6e 74 69 6e 67 20 65 | 69 74 68 65 72 20 62 79 |inting e|ither by|
|00005490| 20 63 6c 69 63 6b 69 6e | 67 20 74 68 69 73 20 62 | clickin|g this b|
|000054a0| 75 74 74 6f 6e 20 6f 72 | 20 62 79 20 63 61 6e 63 |utton or| by canc|
|000054b0| 65 6c 69 6e 67 20 61 20 | 70 72 69 6e 74 65 72 20 |eling a |printer |
|000054c0| 64 69 61 6c 6f 67 20 62 | 6f 78 2c 20 74 68 65 20 |dialog b|ox, the |
|000054d0| 4f 4b 20 73 79 73 74 65 | 6d 20 76 61 72 69 61 62 |OK syste|m variab|
|000054e0| 6c 65 20 69 73 20 73 65 | 74 20 74 6f 20 30 2e 20 |le is se|t to 0. |
|000054f0| 49 66 20 74 68 65 20 70 | 72 69 6e 74 69 6e 67 20 |If the p|rinting |
|00005500| 69 73 20 73 75 63 63 65 | 73 73 66 75 6c 2c 20 74 |is succe|ssful, t|
|00005510| 68 65 20 4f 4b 20 73 79 | 73 74 65 6d 20 76 61 72 |he OK sy|stem var|
|00005520| 69 61 62 6c 65 20 69 73 | 20 73 65 74 20 74 6f 20 |iable is| set to |
|00005530| 31 2e 0d 0d 0d 00 00 0b | f6 41 63 74 69 76 61 74 |1.......|.Activat|
|00005540| 69 6e 67 ca 42 72 65 61 | 6b ca 50 72 6f 63 65 73 |ing.Brea|k.Proces|
|00005550| 73 69 6e 67 20 69 6e 20 | 4c 61 79 6f 75 74 20 52 |sing in |Layout R|
|00005560| 65 70 6f 72 74 73 0d 0d | 0d 42 72 65 61 6b 20 70 |eports..|.Break p|
|00005570| 72 6f 63 65 73 73 69 6e | 67 20 66 6f 72 20 6c 61 |rocessin|g for la|
|00005580| 79 6f 75 74 20 72 65 70 | 6f 72 74 73 20 63 61 6e |yout rep|orts can|
|00005590| 20 62 65 20 61 63 74 69 | 76 61 74 65 64 20 69 6e | be acti|vated in|
|000055a0| 20 74 77 6f 20 77 61 79 | 73 2e 20 54 68 65 20 66 | two way|s. The f|
|000055b0| 69 72 73 74 20 75 73 65 | 73 20 74 68 65 20 ca 53 |irst use|s the .S|
|000055c0| 75 62 74 6f 74 61 6c 20 | 66 75 6e 63 74 69 6f 6e |ubtotal |function|
|000055d0| 2e 20 54 68 65 20 73 65 | 63 6f 6e 64 20 75 73 65 |. The se|cond use|
|000055e0| 73 20 74 68 65 20 42 52 | 45 41 4b ca 4c 45 56 45 |s the BR|EAK.LEVE|
|000055f0| 4c 20 61 6e 64 20 ca 41 | 43 43 55 4d 55 4c 41 54 |L and .A|CCUMULAT|
|00005600| 45 20 63 6f 6d 6d 61 6e | 64 73 2e 20 42 6f 74 68 |E comman|ds. Both|
|00005610| 20 6d 65 74 68 6f 64 73 | 20 63 61 6e 20 61 63 68 | methods| can ach|
|00005620| 69 65 76 65 20 74 68 65 | 20 73 61 6d 65 20 72 65 |ieve the| same re|
|00005630| 73 75 6c 74 73 20 62 75 | 74 20 68 61 76 65 20 64 |sults bu|t have d|
|00005640| 69 66 66 65 72 65 6e 74 | 20 61 64 76 61 6e 74 61 |ifferent| advanta|
|00005650| 67 65 73 2e 0d 0d 0d 0d | 55 73 69 6e 67 20 53 75 |ges.....|Using Su|
|00005660| 62 74 6f 74 61 6c 20 46 | 6f 72 20 42 72 65 61 6b |btotal F|or Break|
|00005670| 20 50 72 6f 63 65 73 73 | 69 6e 67 0d 0d 54 6f 20 | Process|ing..To |
|00005680| 74 75 72 6e 20 6f 6e 20 | 62 72 65 61 6b 20 70 72 |turn on |break pr|
|00005690| 6f 63 65 73 73 69 6e 67 | 20 77 69 74 68 20 74 68 |ocessing| with th|
|000056a0| 65 20 ca 53 75 62 74 6f | 74 61 6c 20 66 75 6e 63 |e .Subto|tal func|
|000056b0| 74 69 6f 6e 2c 20 74 68 | 65 20 66 75 6e 63 74 69 |tion, th|e functi|
|000056c0| 6f 6e 20 6d 75 73 74 20 | 61 70 70 65 61 72 20 69 |on must |appear i|
|000056d0| 6e 20 74 68 65 20 6c 61 | 79 6f 75 74 20 70 72 6f |n the la|yout pro|
|000056e0| 63 65 64 75 72 65 20 6f | 72 20 61 20 73 63 72 69 |cedure o|r a scri|
|000056f0| 70 74 20 66 6f 72 20 74 | 68 65 20 6c 61 79 6f 75 |pt for t|he layou|
|00005700| 74 2e 20 42 65 66 6f 72 | 65 20 70 72 69 6e 74 69 |t. Befor|e printi|
|00005710| 6e 67 20 74 68 65 20 72 | 65 70 6f 72 74 2c 20 34 |ng the r|eport, 4|
|00005720| 74 68 20 44 49 4d 45 4e | 53 49 4f 4e 20 73 63 61 |th DIMEN|SION sca|
|00005730| 6e 73 20 74 68 65 20 6c | 61 79 6f 75 74 20 70 72 |ns the l|ayout pr|
|00005740| 6f 63 65 64 75 72 65 20 | 61 6e 64 20 73 63 72 69 |ocedure |and scri|
|00005750| 70 74 73 20 66 6f 72 20 | 74 68 65 20 ca 53 75 62 |pts for |the .Sub|
|00005760| 74 6f 74 61 6c 20 66 75 | 6e 63 74 69 6f 6e 2e 20 |total fu|nction. |
|00005770| 49 66 20 34 74 68 20 44 | 49 4d 45 4e 53 49 4f 4e |If 4th D|IMENSION|
|00005780| 20 66 69 6e 64 73 20 74 | 68 65 20 66 75 6e 63 74 | finds t|he funct|
|00005790| 69 6f 6e 2c 20 62 72 65 | 61 6b 20 70 72 6f 63 65 |ion, bre|ak proce|
|000057a0| 73 73 69 6e 67 20 69 73 | 20 61 63 74 69 76 61 74 |ssing is| activat|
|000057b0| 65 64 2e 0d 0d 54 68 65 | 20 ca 53 75 62 74 6f 74 |ed...The| .Subtot|
|000057c0| 61 6c 20 66 75 6e 63 74 | 69 6f 6e 20 64 6f 65 73 |al funct|ion does|
|000057d0| 20 6e 6f 74 20 6e 65 65 | 64 20 74 6f 20 62 65 20 | not nee|d to be |
|000057e0| 65 78 65 63 75 74 65 64 | 20 66 6f 72 20 69 74 20 |executed| for it |
|000057f0| 74 6f 20 74 75 72 6e 20 | 6f 6e 20 62 72 65 61 6b |to turn |on break|
|00005800| 20 70 72 6f 63 65 73 73 | 69 6e 67 2e 20 46 6f 72 | process|ing. For|
|00005810| 20 65 78 61 6d 70 6c 65 | 2c 20 69 74 20 63 6f 75 | example|, it cou|
|00005820| 6c 64 20 62 65 20 69 6e | 20 61 20 73 63 72 69 70 |ld be in| a scrip|
|00005830| 74 20 6f 66 20 61 6e 20 | 6f 62 6a 65 63 74 20 74 |t of an |object t|
|00005840| 68 61 74 20 69 73 20 62 | 65 6c 6f 77 20 74 68 65 |hat is b|elow the|
|00005850| 20 46 6f 6f 74 65 72 20 | 6c 69 6e 65 20 61 6e 64 | Footer |line and|
|00005860| 20 74 68 65 72 65 66 6f | 72 65 20 77 6f 75 6c 64 | therefo|re would|
|00005870| 20 6e 65 76 65 72 20 62 | 65 20 70 72 69 6e 74 65 | never b|e printe|
|00005880| 64 20 6f 72 20 65 78 65 | 63 75 74 65 64 2e 20 49 |d or exe|cuted. I|
|00005890| 6e 20 66 61 63 74 2c 20 | 69 66 20 74 68 65 20 ca |n fact, |if the .|
|000058a0| 53 75 62 74 6f 74 61 6c | 20 66 75 6e 63 74 69 6f |Subtotal| functio|
|000058b0| 6e 20 69 73 20 6e 6f 74 | 20 65 78 65 63 75 74 65 |n is not| execute|
|000058c0| 64 2c 20 74 68 65 20 61 | 72 67 75 6d 65 6e 74 20 |d, the a|rgument |
|000058d0| 74 6f 20 74 68 65 20 66 | 75 6e 63 74 69 6f 6e 20 |to the f|unction |
|000058e0| 64 6f 65 73 20 6e 6f 74 | 20 6e 65 65 64 20 74 6f |does not| need to|
|000058f0| 20 62 65 20 76 61 6c 69 | 64 2e 20 46 6f 72 20 65 | be vali|d. For e|
|00005900| 78 61 6d 70 6c 65 2c 20 | 74 68 65 20 66 6f 6c 6c |xample, |the foll|
|00005910| 6f 77 69 6e 67 20 6c 69 | 6e 65 20 77 6f 75 6c 64 |owing li|ne would|
|00005920| 20 74 75 72 6e 20 6f 6e | 20 62 72 65 61 6b 20 70 | turn on| break p|
|00005930| 72 6f 63 65 73 73 69 6e | 67 3a 0d 0d 20 20 20 20 |rocessin|g:.. |
|00005940| 20 20 20 20 78 20 3a 3d | 20 53 75 62 74 6f 74 61 | x :=| Subtota|
|00005950| 6c 20 28 78 29 0d 0d 57 | 68 65 6e 20 ca 53 75 62 |l (x)..W|hen .Sub|
|00005960| 74 6f 74 61 6c 20 69 73 | 20 75 73 65 64 20 74 6f |total is| used to|
|00005970| 20 61 63 74 69 76 61 74 | 65 20 62 72 65 61 6b 20 | activat|e break |
|00005980| 70 72 6f 63 65 73 73 69 | 6e 67 2c 20 79 6f 75 20 |processi|ng, you |
|00005990| 6d 75 73 74 20 73 6f 72 | 74 20 6f 6e 20 6f 6e 65 |must sor|t on one|
|000059a0| 20 6d 6f 72 65 20 6c 65 | 76 65 6c 20 74 68 61 6e | more le|vel than|
|000059b0| 20 79 6f 75 20 62 72 65 | 61 6b 20 6f 6e 2e 20 46 | you bre|ak on. F|
|000059c0| 6f 72 20 65 78 61 6d 70 | 6c 65 2c 20 69 66 20 79 |or examp|le, if y|
|000059d0| 6f 75 20 77 61 6e 74 65 | 64 20 74 77 6f 20 6c 65 |ou wante|d two le|
|000059e0| 76 65 6c 73 20 6f 66 20 | 62 72 65 61 6b 73 20 69 |vels of |breaks i|
|000059f0| 6e 20 79 6f 75 72 20 72 | 65 70 6f 72 74 2c 20 79 |n your r|eport, y|
|00005a00| 6f 75 20 77 6f 75 6c 64 | 20 73 6f 72 74 20 6f 6e |ou would| sort on|
|00005a10| 20 74 68 72 65 65 20 6c | 65 76 65 6c 73 2e 0d 0d | three l|evels...|
|00005a20| 0d 0d 55 73 69 6e 67 20 | 42 52 45 41 4b 20 4c 45 |..Using |BREAK LE|
|00005a30| 56 45 4c 20 61 6e 64 20 | 41 43 43 55 4d 55 4c 41 |VEL and |ACCUMULA|
|00005a40| 54 45 20 46 6f 72 20 42 | 72 65 61 6b 20 50 72 6f |TE For B|reak Pro|
|00005a50| 63 65 73 73 69 6e 67 0d | 0d 59 6f 75 20 63 61 6e |cessing.|.You can|
|00005a60| 20 61 6c 73 6f 20 75 73 | 65 20 74 68 65 20 42 52 | also us|e the BR|
|00005a70| 45 41 4b ca 4c 45 56 45 | 4c 20 61 6e 64 20 ca 41 |EAK.LEVE|L and .A|
|00005a80| 43 43 55 4d 55 4c 41 54 | 45 20 63 6f 6d 6d 61 6e |CCUMULAT|E comman|
|00005a90| 64 73 20 74 6f 20 74 75 | 72 6e 20 6f 6e 20 62 72 |ds to tu|rn on br|
|00005aa0| 65 61 6b 20 70 72 6f 63 | 65 73 73 69 6e 67 2e 20 |eak proc|essing. |
|00005ab0| 49 6e 20 74 68 69 73 20 | 63 61 73 65 2c 20 79 6f |In this |case, yo|
|00005ac0| 75 20 6d 75 73 74 20 65 | 78 65 63 75 74 65 20 62 |u must e|xecute b|
|00005ad0| 6f 74 68 20 6f 66 20 74 | 68 65 73 65 20 63 6f 6d |oth of t|hese com|
|00005ae0| 6d 61 6e 64 73 20 62 65 | 66 6f 72 65 20 70 72 69 |mands be|fore pri|
|00005af0| 6e 74 69 6e 67 20 61 20 | 6c 61 79 6f 75 74 20 72 |nting a |layout r|
|00005b00| 65 70 6f 72 74 2e 20 54 | 68 65 20 ca 53 75 62 74 |eport. T|he .Subt|
|00005b10| 6f 74 61 6c 20 66 75 6e | 63 74 69 6f 6e 20 69 73 |otal fun|ction is|
|00005b20| 20 6e 6f 74 20 72 65 71 | 75 69 72 65 64 20 77 68 | not req|uired wh|
|00005b30| 65 6e 20 75 73 69 6e 67 | 20 74 68 69 73 20 6d 65 |en using| this me|
|00005b40| 74 68 6f 64 2e 0d 0d 57 | 68 65 6e 20 74 68 69 73 |thod...W|hen this|
|00005b50| 20 6d 65 74 68 6f 64 20 | 69 73 20 75 73 65 64 2c | method |is used,|
|00005b60| 20 79 6f 75 20 64 6f 20 | 6e 6f 74 20 6e 65 65 64 | you do |not need|
|00005b70| 20 74 6f 20 73 6f 72 74 | 20 6f 6e 20 6f 6e 65 20 | to sort| on one |
|00005b80| 65 78 74 72 61 20 6c 65 | 76 65 6c 2e 20 59 6f 75 |extra le|vel. You|
|00005b90| 20 6d 75 73 74 2c 20 6f | 66 20 63 6f 75 72 73 65 | must, o|f course|
|00005ba0| 2c 20 73 6f 72 74 20 6f | 6e 20 61 74 20 6c 65 61 |, sort o|n at lea|
|00005bb0| 73 74 20 61 73 20 6d 61 | 6e 79 20 6c 65 76 65 6c |st as ma|ny level|
|00005bc0| 73 20 61 73 20 79 6f 75 | 20 6e 65 65 64 20 74 6f |s as you| need to|
|00005bd0| 20 62 72 65 61 6b 20 6f | 6e 2e 0d 0d 0d 0d 43 6f | break o|n.....Co|
|00005be0| 6d 70 61 72 69 6e 67 20 | 74 68 65 20 54 77 6f 20 |mparing |the Two |
|00005bf0| 4d 65 74 68 6f 64 73 0d | 0d 54 68 65 20 70 72 69 |Methods.|.The pri|
|00005c00| 6d 61 72 79 20 61 64 76 | 61 6e 74 61 67 65 20 6f |mary adv|antage o|
|00005c10| 66 20 75 73 69 6e 67 20 | ca 53 75 62 74 6f 74 61 |f using |.Subtota|
|00005c20| 6c 20 74 6f 20 69 6e 69 | 74 69 61 74 65 20 62 72 |l to ini|tiate br|
|00005c30| 65 61 6b 20 70 72 6f 63 | 65 73 73 69 6e 67 20 69 |eak proc|essing i|
|00005c40| 73 20 74 68 61 74 20 79 | 6f 75 20 64 6f 20 6e 6f |s that y|ou do no|
|00005c50| 74 20 6e 65 65 64 20 74 | 6f 20 65 78 65 63 75 74 |t need t|o execut|
|00005c60| 65 20 61 20 70 72 6f 63 | 65 64 75 72 65 20 70 72 |e a proc|edure pr|
|00005c70| 69 6f 72 20 74 6f 20 70 | 72 69 6e 74 69 6e 67 20 |ior to p|rinting |
|00005c80| 74 68 65 20 72 65 70 6f | 72 74 2e 20 54 68 69 73 |the repo|rt. This|
|00005c90| 20 69 73 20 65 73 70 65 | 63 69 61 6c 6c 79 20 75 | is espe|cially u|
|00005ca0| 73 65 66 75 6c 20 69 6e | 20 74 68 65 20 55 73 65 |seful in| the Use|
|00005cb0| 72 20 65 6e 76 69 72 6f | 6e 6d 65 6e 74 2e 20 54 |r enviro|nment. T|
|00005cc0| 68 65 20 70 72 6f 63 65 | 73 73 20 74 6f 20 70 72 |he proce|ss to pr|
|00005cd0| 69 6e 74 20 74 68 65 20 | 72 65 70 6f 72 74 20 69 |int the |report i|
|00005ce0| 6e 20 74 68 65 20 55 73 | 65 72 20 65 6e 76 69 72 |n the Us|er envir|
|00005cf0| 6f 6e 6d 65 6e 74 20 69 | 73 20 74 79 70 69 63 61 |onment i|s typica|
|00005d00| 6c 6c 79 20 6c 69 6b 65 | 20 74 68 69 73 3a 0d 0d |lly like| this:..|
|00005d10| 20 20 20 20 20 20 31 2e | 20 53 65 6c 65 63 74 20 | 1.| Select |
|00005d20| 74 68 65 20 72 65 63 6f | 72 64 73 20 74 6f 20 62 |the reco|rds to b|
|00005d30| 65 20 70 72 69 6e 74 65 | 64 2e 0d 20 20 20 20 20 |e printe|d.. |
|00005d40| 20 32 2e 20 53 6f 72 74 | 20 74 68 65 20 72 65 63 | 2. Sort| the rec|
|00005d50| 6f 72 64 73 2c 20 73 6f | 72 74 69 6e 67 20 6f 6e |ords, so|rting on|
|00005d60| 20 6f 6e 65 20 65 78 74 | 72 61 20 6c 65 76 65 6c | one ext|ra level|
|00005d70| 2e 20 0d 20 20 20 20 20 | 20 33 2e 20 43 68 6f 6f |. . | 3. Choo|
|00005d80| 73 65 20 50 72 69 6e 74 | 20 66 72 6f 6d 20 74 68 |se Print| from th|
|00005d90| 65 20 46 69 6c 65 20 6d | 65 6e 75 2e 0d 0d 34 74 |e File m|enu...4t|
|00005da0| 68 20 44 49 4d 45 4e 53 | 49 4f 4e 20 73 63 61 6e |h DIMENS|ION scan|
|00005db0| 73 20 74 68 65 20 6c 61 | 79 6f 75 74 20 70 72 6f |s the la|yout pro|
|00005dc0| 63 65 64 75 72 65 20 61 | 6e 64 20 73 63 72 69 70 |cedure a|nd scrip|
|00005dd0| 74 73 2c 20 66 69 6e 64 | 73 20 74 68 65 20 ca 53 |ts, find|s the .S|
|00005de0| 75 62 74 6f 74 61 6c 20 | 66 75 6e 63 74 69 6f 6e |ubtotal |function|
|00005df0| 2c 20 74 75 72 6e 73 20 | 6f 6e 20 62 72 65 61 6b |, turns |on break|
|00005e00| 20 70 72 6f 63 65 73 73 | 69 6e 67 2c 20 61 6e 64 | process|ing, and|
|00005e10| 20 70 72 69 6e 74 73 20 | 74 68 65 20 72 65 70 6f | prints |the repo|
|00005e20| 72 74 2e 0d 0d 54 68 65 | 72 65 20 61 72 65 20 74 |rt...The|re are t|
|00005e30| 77 6f 20 64 69 73 61 64 | 76 61 6e 74 61 67 65 73 |wo disad|vantages|
|00005e40| 20 74 6f 20 75 73 69 6e | 67 20 ca 53 75 62 74 6f | to usin|g .Subto|
|00005e50| 74 61 6c 20 74 6f 20 74 | 72 69 67 67 65 72 20 62 |tal to t|rigger b|
|00005e60| 72 65 61 6b 20 70 72 6f | 63 65 73 73 69 6e 67 3a |reak pro|cessing:|
|00005e70| 20 0d 0d a5 20 59 6f 75 | 20 63 61 6e 6e 6f 74 20 | ... You| cannot |
|00005e80| 75 73 65 20 ca 53 75 62 | 74 6f 74 61 6c 20 74 6f |use .Sub|total to|
|00005e90| 20 61 63 74 69 76 61 74 | 65 20 62 72 65 61 6b 20 | activat|e break |
|00005ea0| 70 72 6f 63 65 73 73 69 | 6e 67 20 69 6e 20 63 6f |processi|ng in co|
|00005eb0| 6d 70 69 6c 65 64 20 0d | 20 20 20 20 20 20 20 20 |mpiled .| |
|00005ec0| 20 20 64 61 74 61 62 61 | 73 65 73 0d a5 20 59 6f | databa|ses.. Yo|
|00005ed0| 75 20 6d 75 73 74 20 73 | 6f 72 74 20 6f 6e 20 6f |u must s|ort on o|
|00005ee0| 6e 65 20 65 78 74 72 61 | 20 6c 65 76 65 6c 3b 20 |ne extra| level; |
|00005ef0| 69 66 20 79 6f 75 20 68 | 61 76 65 20 6d 61 6e 79 |if you h|ave many|
|00005f00| 20 72 65 63 6f 72 64 73 | 2c 20 74 68 69 73 20 6d | records|, this m|
|00005f10| 61 79 20 62 65 20 74 69 | 6d 65 20 63 6f 6e 73 75 |ay be ti|me consu|
|00005f20| 6d 69 6e 67 0d 0d 0d 55 | 73 69 6e 67 20 42 52 45 |ming...U|sing BRE|
|00005f30| 41 4b ca 4c 45 56 45 4c | 20 61 6e 64 20 ca 41 43 |AK.LEVEL| and .AC|
|00005f40| 43 55 4d 55 4c 41 54 45 | 20 74 6f 20 61 63 74 69 |CUMULATE| to acti|
|00005f50| 76 61 74 65 20 62 72 65 | 61 6b 20 70 72 6f 63 65 |vate bre|ak proce|
|00005f60| 73 73 69 6e 67 20 69 73 | 20 74 68 65 20 72 65 63 |ssing is| the rec|
|00005f70| 6f 6d 6d 65 6e 64 65 64 | 20 6d 65 74 68 6f 64 20 |ommended| method |
|00005f80| 77 68 65 6e 20 75 73 69 | 6e 67 20 70 72 6f 63 65 |when usi|ng proce|
|00005f90| 64 75 72 65 73 20 74 6f | 20 67 65 6e 65 72 61 74 |dures to| generat|
|00005fa0| 65 20 6c 61 79 6f 75 74 | 20 72 65 70 6f 72 74 73 |e layout| reports|
|00005fb0| 2e 20 54 68 65 20 70 72 | 6f 63 65 73 73 20 74 6f |. The pr|ocess to|
|00005fc0| 20 70 72 69 6e 74 20 61 | 20 72 65 70 6f 72 74 20 | print a| report |
|00005fd0| 75 73 69 6e 67 20 74 68 | 69 73 20 6d 65 74 68 6f |using th|is metho|
|00005fe0| 64 20 69 73 20 74 79 70 | 69 63 61 6c 6c 79 20 6c |d is typ|ically l|
|00005ff0| 69 6b 65 20 74 68 69 73 | 3a 0d 0d 20 20 20 20 20 |ike this|:.. |
|00006000| 20 31 2e 20 53 65 6c 65 | 63 74 20 74 68 65 20 72 | 1. Sele|ct the r|
|00006010| 65 63 6f 72 64 73 20 74 | 6f 20 62 65 20 70 72 69 |ecords t|o be pri|
|00006020| 6e 74 65 64 2e 0d 20 20 | 20 20 20 20 32 2e 20 53 |nted.. | 2. S|
|00006030| 6f 72 74 20 74 68 65 20 | 72 65 63 6f 72 64 73 2e |ort the |records.|
|00006040| 20 53 6f 72 74 20 6f 6e | 20 61 74 20 6c 65 61 73 | Sort on| at leas|
|00006050| 74 20 74 68 65 20 73 61 | 6d 65 20 6e 75 6d 62 65 |t the sa|me numbe|
|00006060| 72 20 6f 66 20 6c 65 76 | 65 6c 73 20 61 73 20 0d |r of lev|els as .|
|00006070| 20 20 20 20 20 20 20 20 | 20 20 20 20 62 72 65 61 | | brea|
|00006080| 6b 73 2e 0d 20 20 20 20 | 20 20 33 2e 20 45 78 65 |ks.. | 3. Exe|
|00006090| 63 75 74 65 20 42 52 45 | 41 4b ca 4c 45 56 45 4c |cute BRE|AK.LEVEL|
|000060a0| 20 61 6e 64 20 ca 41 43 | 43 55 4d 55 4c 41 54 45 | and .AC|CUMULATE|
|000060b0| 2e 0d 20 20 20 20 20 20 | 34 2e 20 50 72 69 6e 74 |.. |4. Print|
|000060c0| 20 74 68 65 20 72 65 70 | 6f 72 74 2e 0d 0d 59 6f | the rep|ort...Yo|
|000060d0| 75 20 6d 75 73 74 20 75 | 73 65 20 42 52 45 41 4b |u must u|se BREAK|
|000060e0| ca 4c 45 56 45 4c 20 61 | 6e 64 20 ca 41 43 43 55 |.LEVEL a|nd .ACCU|
|000060f0| 4d 55 4c 41 54 45 20 74 | 6f 20 61 63 74 69 76 61 |MULATE t|o activa|
|00006100| 74 65 20 62 72 65 61 6b | 20 70 72 6f 63 65 73 73 |te break| process|
|00006110| 69 6e 67 20 69 6e 20 63 | 6f 6d 70 69 6c 65 64 20 |ing in c|ompiled |
|00006120| 70 72 6f 63 65 64 75 72 | 65 73 2e 0d 0d 0d 0d 00 |procedur|es......|
|00006130| 00 0d 00 53 45 41 52 43 | 48 ca 41 4e 44 ca 53 4f |...SEARC|H.AND.SO|
|00006140| 52 54 0d 0d 0d 0d 54 68 | 65 20 34 74 68 20 44 49 |RT....Th|e 4th DI|
|00006150| 4d 45 4e 53 49 4f 4e 20 | 6c 61 6e 67 75 61 67 65 |MENSION |language|
|00006160| 20 63 6f 6e 74 61 69 6e | 73 20 61 20 6e 75 6d 62 | contain|s a numb|
|00006170| 65 72 20 6f 66 20 63 6f | 6d 6d 61 6e 64 73 20 79 |er of co|mmands y|
|00006180| 6f 75 20 63 61 6e 20 75 | 73 65 20 74 6f 20 73 65 |ou can u|se to se|
|00006190| 61 72 63 68 20 66 6f 72 | 20 72 65 63 6f 72 64 73 |arch for| records|
|000061a0| 2e 20 54 68 65 79 20 61 | 6c 6c 20 70 65 72 66 6f |. They a|ll perfo|
|000061b0| 72 6d 20 74 68 65 20 73 | 61 6d 65 20 62 61 73 69 |rm the s|ame basi|
|000061c0| 63 20 72 6f 6c 65 d1 20 | 73 65 61 72 63 68 69 6e |c role. |searchin|
|000061d0| 67 20 74 68 72 6f 75 67 | 68 20 74 68 65 20 72 65 |g throug|h the re|
|000061e0| 63 6f 72 64 73 20 6f 66 | 20 61 20 66 69 6c 65 2c |cords of| a file,|
|000061f0| 20 6c 6f 6f 6b 69 6e 67 | 20 66 6f 72 20 72 65 63 | looking| for rec|
|00006200| 6f 72 64 73 20 74 68 61 | 74 20 6d 61 74 63 68 20 |ords tha|t match |
|00006210| 61 20 73 65 74 20 6f 66 | 20 63 72 69 74 65 72 69 |a set of| criteri|
|00006220| 61 d1 62 75 74 20 65 61 | 63 68 20 64 6f 65 73 20 |a.but ea|ch does |
|00006230| 74 68 65 20 74 61 73 6b | 20 69 6e 20 61 20 64 69 |the task| in a di|
|00006240| 66 66 65 72 65 6e 74 20 | 77 61 79 2e 20 57 68 65 |fferent |way. Whe|
|00006250| 6e 20 65 61 63 68 20 63 | 6f 6d 6d 61 6e 64 20 68 |n each c|ommand h|
|00006260| 61 73 20 66 69 6e 69 73 | 68 65 64 20 65 78 65 63 |as finis|hed exec|
|00006270| 75 74 69 6e 67 2c 20 69 | 74 20 63 72 65 61 74 65 |uting, i|t create|
|00006280| 73 20 61 20 73 65 6c 65 | 63 74 69 6f 6e 20 6f 66 |s a sele|ction of|
|00006290| 20 74 68 65 20 72 65 63 | 6f 72 64 73 20 74 68 61 | the rec|ords tha|
|000062a0| 74 20 77 65 72 65 20 66 | 6f 75 6e 64 2e 20 54 68 |t were f|ound. Th|
|000062b0| 65 72 65 20 61 72 65 20 | 61 6c 73 6f 20 73 65 76 |ere are |also sev|
|000062c0| 65 72 61 6c 20 63 6f 6d | 6d 61 6e 64 73 20 74 6f |eral com|mands to|
|000062d0| 20 73 6f 72 74 20 74 68 | 65 20 72 65 63 6f 72 64 | sort th|e record|
|000062e0| 73 2e 20 54 68 65 73 65 | 20 63 6f 6d 6d 61 6e 64 |s. These| command|
|000062f0| 73 20 6f 72 64 65 72 20 | 74 68 65 20 72 65 63 6f |s order |the reco|
|00006300| 72 64 73 20 62 61 73 65 | 64 20 6f 6e 20 74 68 65 |rds base|d on the|
|00006310| 20 63 72 69 74 65 72 69 | 61 20 73 70 65 63 69 66 | criteri|a specif|
|00006320| 69 65 64 2e 0d 0d 20 ca | 53 45 41 52 43 48 0d 20 |ied... .|SEARCH. |
|00006330| 20 53 45 41 52 43 48 ca | 42 59 ca 46 4f 52 4d 55 | SEARCH.|BY.FORMU|
|00006340| 4c 41 0d 20 20 53 45 41 | 52 43 48 ca 42 59 ca 49 |LA. SEA|RCH.BY.I|
|00006350| 4e 44 45 58 0d 20 20 53 | 45 41 52 43 48 ca 42 59 |NDEX. S|EARCH.BY|
|00006360| ca 4c 41 59 4f 55 54 0d | 20 20 53 45 41 52 43 48 |.LAYOUT.| SEARCH|
|00006370| ca 53 45 4c 45 43 54 49 | 4f 4e 0d 20 20 53 45 41 |.SELECTI|ON. SEA|
|00006380| 52 43 48 ca 53 45 4c 45 | 43 54 49 4f 4e ca 42 59 |RCH.SELE|CTION.BY|
|00006390| ca 46 4f 52 4d 55 4c 41 | 0d 20 20 53 4f 52 54 ca |.FORMULA|. SORT.|
|000063a0| 42 59 ca 46 4f 52 4d 55 | 4c 41 0d 20 20 53 4f 52 |BY.FORMU|LA. SOR|
|000063b0| 54 ca 42 59 ca 49 4e 44 | 45 58 0d 20 20 53 4f 52 |T.BY.IND|EX. SOR|
|000063c0| 54 ca 53 45 4c 45 43 54 | 49 4f 4e 0d 0d 0d 53 65 |T.SELECT|ION...Se|
|000063d0| 61 72 63 68 65 73 20 6d | 61 79 20 62 65 20 73 69 |arches m|ay be si|
|000063e0| 6d 70 6c 65 20 6f 72 20 | 63 6f 6d 70 6c 65 78 2e |mple or |complex.|
|000063f0| 20 59 6f 75 20 63 61 6e | 20 73 65 61 72 63 68 20 | You can| search |
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
